| 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) | |||
Linear Mode
