Hello everyone!
I have a problem with numeric input (decimal places). For example when im entering a number 16,48 in a cell it looks right but in formula bar it shows 16,4807150561798 instead of 16,48. How do i fix this, so that cell number is equal to the number in the formula bar?
In other excel there are no such problems.
Screenshot:
Screenshot 2019-12-17 at 15.49.03.png
Thanks in advance for any help!
John!
Last edited by desikik; 12-17-2019 at 04:15 PM.
I don't think I have seen this before!!
Please attach a sheet showing this problem (read yellow banner at the top of the screen for guidance on attaching a file).
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks for the reply!Originally Posted by Glenn Kennedy
As i said, there is no problem with other PCs. It is only for one. I would like to solve this problem without reinstall excel.
File in attachment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks