Add more numbers

  • Thread starter Thread starter Golfinray
  • Start date Start date
G

Golfinray

I have a column that is numbers in ####-### format, like 3454-982. I would
like to add 0709- to the front of all these numbers, like 0709-3454-982. How?
Thanks a bunch!!!!
 
="0709-"&TEXT(A2,"####-###") will give a text result,
or =7090000000+A2 and format as ####-####-###
 
Insert a helper column to the right of your current data column. In the
first cell of the new column, enter the following formula:

="0709-"&A1

Changing cell A1 to match the cell to the right of the formula. Copy the
formula down the column and then select all the cells in the column that
contain the formula. After selecting the column of formulas, click EDIT in
the menu and select COPY. Move to the first cell in your original column of
numbers, click EDIT in the menu and select PASTE SPECIAL. Click the VALUES
option button and click OK.

YOu can now delete the helper column
 
Back
Top