Number format still uses decimal point

  • Thread starter Thread starter BecknRoos
  • Start date Start date
B

BecknRoos

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.
 
Do you have fixed decimal turned on?

Check Tools/Options/Edit - uncheck fixed decimal.
 
FANTASTIC!!!! Thank you SO much for the help.
God Bless all that help those of us with problems.

Do you have fixed decimal turned on?

Check Tools/Options/Edit - uncheck fixed decimal.
 
You're most welcome. Glad to help.

BecknRoos said:
FANTASTIC!!!! Thank you SO much for the help.
God Bless all that help those of us with problems.

Do you have fixed decimal turned on?

Check Tools/Options/Edit - uncheck fixed decimal.
Click to expand...
 
Back
Top