Strange Cell Format Behavior
 

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.
--
LFP

Strange Cell Format Behavior
 

Tools Options Edit Uncheck Fixed decimal Places:


"LFP" wrote:

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.
--
LFP

Strange Cell Format Behavior
 

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.

"LFP" wrote:

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.
--
LFP

Strange Cell Format Behavior
 

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" wrote in message
...
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.
--
LFP

Strange Cell Format Behavior
 

Hi,

from main menu ... Tools Options Edit

Clear Fixed decimals ...

HTH

Strange Cell Format Behavior
 

Thanks, this worked.
--
LFP


"Bernard Liengme" wrote:

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" wrote in message
...
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.
--
LFP

Strange Cell Format Behavior
 

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


"BoniM" wrote:

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.

"LFP" wrote:

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.
--
LFP