Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i insert information into the beginning of every field?
I have transported mobile telephone numbers from our database into excel and
it has deleted all the "0" I would like to reinsert all with "0" or +44 without having to manually type this in at the beginning of every field? |
#2
|
|||
|
|||
You could use another column alongside and enter the formula (Presuming
column A) ="0"&A1 HTH Nick Hodge "Pinkwilphil" wrote: I have transported mobile telephone numbers from our database into excel and it has deleted all the "0" I would like to reinsert all with "0" or +44 without having to manually type this in at the beginning of every field? |
#3
|
|||
|
|||
Thank you very much, done it at last!
"Pinkwilphil" wrote: I have transported mobile telephone numbers from our database into excel and it has deleted all the "0" I would like to reinsert all with "0" or +44 without having to manually type this in at the beginning of every field? |
#4
|
|||
|
|||
If you type another number that starts with zero, you can type an
apostrophe ( ' ) in front of the number, e.g. '012345 The apostrophe won't show in the cell, after you press the Enter key, and the leading zero will be kept. The apostrophe tells Excel to treat the number like text, instead of a number. Pinkwilphil wrote: Thank you very much, done it at last! "Pinkwilphil" wrote: I have transported mobile telephone numbers from our database into excel and it has deleted all the "0" I would like to reinsert all with "0" or +44 without having to manually type this in at the beginning of every field? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Challenging Charting | Charts and Charting in Excel | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
I need to know how to insert my information, time and tides in ex. | Charts and Charting in Excel | |||
How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
insert worksheet gives me 3 duplicate sheets not one | Excel Discussion (Misc queries) |