| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
add numbers in excel
How do I add a number such as +27 before a tel number, in a very large column
in excel. All the numbers should start with + 27. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
add numbers in excel
="+27 "&A1
HTH Carim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
add numbers in excel
If your list is in column A starting in cell A1, pick an empty column and
write the formula ="+27 "&A1 in a cell in the empty column which is in the same row as the first value in the original column. Then copy the formula down to the length of the original list. then select the new list and copy it, go to the top of your original list and paste, select the paste options icon (bottom right of the pasted list) and pick values and source formatting, now delete the list with the formula. "pleasehelpurgently" wrote: How do I add a number such as +27 before a tel number, in a very large column in excel. All the numbers should start with + 27. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the way numbers are displayed in Excel 2003 SP2 | Excel Discussion (Misc queries) | |||
| How to switch negative numbers to positive numbers in Excel ? | Excel Worksheet Functions | |||
| Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
| 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 | |||
Linear Mode
