Strange Cell Format Behavior

[LFP]

I have my cells formatted as general. When I input the number 1470 it makes
it 14.7 When I switch the formatting to a number with no decimal places and
type in 1470 it changes it to the number 15. I just want to input the whole
number 1470.

 

[Teethless mama]

Tools >> Options >> Edit >> Uncheck Fixed decimal Places:

 

[BoniM]

Go to Tools > Options > Edit tab > Fixed decimal places has been set to 2.
Remove the check from fixed decimal places to turn it off, or type 147000 to
enter 1470.

 

[Bernard Liengme]

Your Excel is setup for 'lazy' money entries - every thing gets two decimal
places for cents/pennies
Use Tools | Options ; open the Edit tab; in the left centre locate a box
called Fixed Decimal Places and uncheck this box
best wishes

 

[Carim]

Hi,

from main menu ... Tools Options Edit

Clear Fixed decimals ...

HTH

 

[LFP]

Thanks, this worked.
--
LFP

Your Excel is setup for 'lazy' money entries - every thing gets two decimal
places for cents/pennies
Use Tools | Options ; open the Edit tab; in the left centre locate a box
called Fixed Decimal Places and uncheck this box
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

 

[LFP]

Thanks so much, no idea how it got set that way in the 1st place.