View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Danny@Kendal
 
Posts: n/a
Default 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?