Did you get that to work?


--


Regards,


Peo Sjoblom




"Rick Rothstein (MVP - VB)" wrote in
message ...
I have a spreadsheet of data that was downloaded from a corporate system.
One of the fields is formatted as text - '00000454589. I would like to
remove all the leading zeros at the front of each number in that column.
The
only way I can seem to do it is to physically click in each cell and
delete
the apostrophe. Does anyone have any suggestions on how I can do that
all at
once for all 1400 plus numbers I have in that column?

Still another method.... select the entire column, click Edit/Replace on
Excel's menu bar (or just key-in Ctrl+H), put an apostrophe in the "Find
what" field, leave the "Replace with" field blank and press the "Replace
All" button.

Rick