add number to existing text numbers

  • Thread starter Thread starter Stacy
  • Start date Start date
S

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?
 
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'
 
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!
 
Back
Top