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.