How do i insert information into the beginning of every field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You could use another column alongside and enter the formula (Presuming
column A)

="0"&A1
HTH
Nick Hodge
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting a zero 5
how to show numbers that begin with 0 in excel 2
Page Number Troubleshooting 4
CSV files & phone numbers 1
in 2003 i have 0 text file conrt to 2007 number 1
how do in input phone numbers starting with 0 into excel 4
How can I keep a zero at the beginning of a mobile number? 3
Import files into access 1

Back
Top