Copy an empty cell, then select all your cells that have these numbers and
use Edit-Paste Special-Values-Add


"Carla" wrote:

Hi,

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?

thanks.

Carla