| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Number format still uses decimal point
I have Excel 2002 SP3 and when I format cells to use numbers all numbers
show up with a decimal and then are rounded up. For example. I want to put inventory numbers in column A such as number 394. The result is that the number shows up in the formula bar as three POINT nine four and in column A as a 4. Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Number format still uses decimal point
Do you have fixed decimal turned on?
Check Tools/Options/Edit - uncheck fixed decimal. "BecknRoos" wrote: I have Excel 2002 SP3 and when I format cells to use numbers all numbers show up with a decimal and then are rounded up. For example. I want to put inventory numbers in column A such as number 394. The result is that the number shows up in the formula bar as three POINT nine four and in column A as a 4. Any help would be appreciated. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Number format still uses decimal point
FANTASTIC!!!! Thank you SO much for the help.
God Bless all that help those of us with problems. "JMB" wrote in message ... Do you have fixed decimal turned on? Check Tools/Options/Edit - uncheck fixed decimal. "BecknRoos" wrote: I have Excel 2002 SP3 and when I format cells to use numbers all numbers show up with a decimal and then are rounded up. For example. I want to put inventory numbers in column A such as number 394. The result is that the number shows up in the formula bar as three POINT nine four and in column A as a 4. Any help would be appreciated. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Number format still uses decimal point
You're most welcome. Glad to help.
"BecknRoos" wrote: FANTASTIC!!!! Thank you SO much for the help. God Bless all that help those of us with problems. "JMB" wrote in message ... Do you have fixed decimal turned on? Check Tools/Options/Edit - uncheck fixed decimal. "BecknRoos" wrote: I have Excel 2002 SP3 and when I format cells to use numbers all numbers show up with a decimal and then are rounded up. For example. I want to put inventory numbers in column A such as number 394. The result is that the number shows up in the formula bar as three POINT nine four and in column A as a 4. Any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show decimal point only if not a whole number | Excel Discussion (Misc queries) | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| position of decimal point when entering a number ... | Excel Discussion (Misc queries) | |||
| format inplied decimal point | Excel Discussion (Misc queries) | |||
| How do I round last number without a decimal point | Excel Worksheet Functions | |||
Linear Mode
