Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Numbers typed into Excel 2003 read as whole numbers | Excel Discussion (Misc queries) | |||
Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
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? | Excel Worksheet Functions | |||
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? | Excel Worksheet Functions | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions |