View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

go to ToolsOptionsEdit and uncheck the option for Fixed Decimal Places

"Shane" wrote:

I have a user who's numbers in excel are defaulting to a decimal even if you
format the cell for number zero decimal places. For example if she enters 15
it will enter .15. This happens on every excel document she opens and if you
open the same documents on another PC they work fine. I have even tried to
reinstall excel on the PC and it does not correct the Issue. Please help with
suggestions.

For a work around I have her entering 15. But that is an extra key stroke.
Thanks