Number format still uses decimal point

[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.

 

[JMB]

Do you have fixed decimal turned on?

Check Tools/Options/Edit - uncheck fixed decimal.

 

[BecknRoos]

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.

 

[JMB]

You're most welcome. Glad to help.

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.