Add more numbers

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!!!!
 
D

David Biddulph

="0709-"&TEXT(A2,"####-###") will give a text result,
or =7090000000+A2 and format as ####-####-###
 
D

David Biddulph

Correction to the second suggestion:
=7090000000+A2 and format as 0###-####-###
 
K

Kevin B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify numbers 5
retrieving values from a certain column 2
trim data and search for text strings 5
Unique filtering to another sheet ? 6
Data Filtering 7
Isnull with a filter problem 4
How to import address list tables into Excel 2
List differences 11

Top