Add more numbers
 

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

Add more numbers
 

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

"Golfinray" wrote in message
...
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!!!!

Add more numbers
 

Hi

Use custom format:

0709-####-###

Regards,
Per

"Golfinray" skrev i meddelelsen
...
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!!!!

Add more numbers
 

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

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
="0709-"&TEXT(A2,"####-###") will give a text result,
or =7090000000+A2 and format as ####-####-###
--
David Biddulph

"Golfinray" wrote in message
...
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!!!!

Add more numbers
 

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
--
Kevin Backmann


"Golfinray" wrote:

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