Add more numbers

's Computer Specifications

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

's Computer Specifications

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

"Golfinray" <(E-Mail Removed)> wrote in message
news:2969FDF6-1D44-4D29-B578-(E-Mail Removed)...
>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!!!!

's Computer Specifications

Hi

Use custom format:

0709-####-###

Regards,
Per

"Golfinray" <(E-Mail Removed)> skrev i meddelelsen
news:2969FDF6-1D44-4D29-B578-(E-Mail Removed)...
>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!!!!

's Computer Specifications

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

"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
news:4859030a$(E-Mail Removed)...
> ="0709-"&TEXT(A2,"####-###") will give a text result,
> or =7090000000+A2 and format as ####-####-###
> --
> David Biddulph
>
> "Golfinray" <(E-Mail Removed)> wrote in message
> news:2969FDF6-1D44-4D29-B578-(E-Mail Removed)...
>>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!!!!
>
>

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert numbers stored as text to numbers errors after loading data in	jobs	Microsoft Excel Programming	2	28th Mar 2007 02:57 AM
Need to reconcile numbers accounting Harlan Grove code doesn't work for negative numbers	aep002@cox.net	Microsoft Excel Programming	1	28th Jul 2006 07:09 AM
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?	C-Man23	Microsoft Excel Worksheet Functions	3	19th Jan 2006 09:52 AM
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?	C-Man23	Microsoft Excel Worksheet Functions	1	9th Jan 2006 01:23 PM
Change positive numbers (debits) to negative numbers (credits)	=?Utf-8?B?Q2FybGEgR2lsbGVzcw==?=	Microsoft Access VBA Modules	4	17th Dec 2004 06:50 PM