when I enter "100" in a cell it displays "1" - can anyone help me out?
when I enter "100" in a cell it displays "1" - can anyone help me out?
What format is the cell? Right click, Format cells > Number > General?
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Yes, that is the formatting - I've tried other formatting and it makes no difference.
Any code in the workbook?
Try
Tools > Options > Edit
If "Fixed decimal places" is ticked untick it > OK
Good catch, dll. I have never used it, and would never have thought of it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks