Hi

How is the column currently formatted?
Is it Custom00000?
If so, change the format to Custom000
If it is Text, then copy a blank cellmark the range of your dataPaste
SpecialAdd.
This should change you values from Text to Numeric.

--
Regards
Roger Govier

"mokihi" wrote in message
...
I have a giant list in one column full of data that is prefixed by zeros.

eg. 271 is represented as 00271, 274 as 00274

I am trying to remove these zeros so as to be able to merge and sort this
data with another set.

Can anyone tell me how to remove these zeros from the data without
manually
typing them in?