102. not entering the same as 102.00
"Stacy" wrote in message
...
I have the most unusual problem. I have fixed decimal places on -- set to
2.
When I enter 102. (102 decimal), the cell value is entered as 1.02. I want
it
to be 102.00. I can't figure out how to change this setting and my
computer
seems to be the only doing this in the office. Spreadsheets are coming out
wrong b/c 102. is habit -- not 102.00.
For Excel2000
Tools - Options - Edit
Is the "fixed decimal places" box checked? If so, un-check it.
Did that help?
|