View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Excel number entry

hi
2003....
on the menu bar...Toolsoptionsedit tabuncheck fixed decimal places
2007...
i think....office buttonexcel optionsect.

regards
FSt1

"redmond" wrote:

opened a spreadsheet today and when entering a number i get .xx, that is when
i enter 5 in a cell it shows as .05
Any suggestions on how to fix? thanks