View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roy Roy is offline
external usenet poster
 
Posts: 53
Default i did something wrong

thx, that did it

"garfield-n-odie [MVP]" wrote:

In Excel, click on Tools | Options | Edit | uncheck the "Fixed
decimal places" box | OK.

Roy wrote:

Good afternoon,
i must have hit something in the options or format, I have a spread sheet
and when entering numbers, it now will take my number (175) and goes to 1.75,
tried changing the cells format to no decimal places and now just puts a 2
there, any ideas where I went wrong, all I want is regular numbers as I
entered 175