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


"Rick Rothstein" wrote:

Is this happening only in the column you formatted or in any cell in the
worksheet? If the latter, click Tools/Options on the menu bar, select the
Edit tab on the dialog box that appears and remove the check mark from the
CheckBox labeled "Fixed decimal"

--
Rick (MVP - Excel)


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