Either the cells are formatted as text or have a custom format applied.

First I'd try to select the cells (or entire column) and then use
Edit | Clear | Formats
and see if that clears it up.

If not, again choose them and use
Format | Cells | [General]


"Kathy Marie" wrote:

I need a macro that can delete zero's from a range of cells-the numbers all
start with 0 for example-000222, next cell 000228.
I want to delete the zeros but leave the rest of the number. when I write a
macro, it replaces the number with a constant rather than leaving the new
number in each cell-
can anyone help?

Thanks, Kathy Beck