Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Numbers display as 4.5 instead of 45
I want to be able to type in two digit numbers without them displaying as a
one digit number with a decimal. i.e. I want to type 45 and have it show up as 45 and not 4.5. I can accomplish this by formatting the cells as text, but then my functions don't work. Seems like there has to be an easy answer? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Numbers display as 4.5 instead of 45
This is the normal way for Excel to behave. I type 69 and I get 69. If you
get 6.9 then somehow your Excel has been set to customized to add the decimal. Solution: use Tools | Options and open the Edit tab; uncheck the box labelled "Fixed decimal" best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "LCK" wrote in message ... I want to be able to type in two digit numbers without them displaying as a one digit number with a decimal. i.e. I want to type 45 and have it show up as 45 and not 4.5. I can accomplish this by formatting the cells as text, but then my functions don't work. Seems like there has to be an easy answer? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Numbers display as 4.5 instead of 45
Thanks, that worked!
"Bernard Liengme" wrote: This is the normal way for Excel to behave. I type 69 and I get 69. If you get 6.9 then somehow your Excel has been set to customized to add the decimal. Solution: use Tools | Options and open the Edit tab; uncheck the box labelled "Fixed decimal" best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "LCK" wrote in message ... I want to be able to type in two digit numbers without them displaying as a one digit number with a decimal. i.e. I want to type 45 and have it show up as 45 and not 4.5. I can accomplish this by formatting the cells as text, but then my functions don't work. Seems like there has to be an easy answer? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I display row numbers on the scroll bar? | Excel Discussion (Misc queries) | |||
display negative numbers as zero | Excel Discussion (Misc queries) | |||
Format cells to display ordinal numbers ex 21st | Excel Worksheet Functions | |||
HOW DO I DISPLAY NUMBERS AS WORDS IN EXCEL 2003? | Excel Discussion (Misc queries) | |||
entering numbers to display a time format | Excel Discussion (Misc queries) |