If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|