Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Strange Cell Format Behavior
Hi, from main menu ... Tools Options Edit Clear Fixed decimals ... HTH |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange behavior on launching. | Setting up and Configuration of Excel | |||
Strange behavior | Excel Discussion (Misc queries) | |||
Excel Mac OS X - Strange Behavior | Excel Discussion (Misc queries) | |||
Strange behavior | Setting up and Configuration of Excel | |||
Strange behavior. | Excel Discussion (Misc queries) |