i did something wrong
 

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

i did something wrong
 

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

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

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