add number to existing text numbers

[Stacy]

I have 2000 columns with accounting type text numbers in
each cell, i.e. 0345999, 058956, ect.

I want to add an "0" in front of each account number.
Anyone know how to do this withount going into each cell
and doing it by hand?

 

[Frank Kabel]

Hi
one way: use a helper column with the formula
="0" & A1
copy this down for all rows, copy this column and insert it with
'Edit - Paste Special - Values'

 

[Guest]

Hi

You could use a helper column with
="0"&A2
and fill this down. Select the range and Edit / Copy / Edit / Paste Special
.. . Values to fix these in place. A better alternative would be a macro - so
if you hold on I'm sure someone will post one!