Thanks worked fine. didn't know that tab existed.

"Bob Umlas" wrote:

Toola/Options/Edit tab, deselect "Fixed Decimal Places"
Bob Umlas
Excel MVP

"mibes" wrote in message
...
I want to format a column in excel 2003. I click on general because all I
want is a number. If I put the number 2 it shows .02. I do not want a
decimal
number. How do I change this so I just have any number without decimal.