Looking to add a leading 0 @ start of numbers
 

Greetings all.

I have a database of contact details, and I am now looking to add a
leading 0 to the beginning of my data field "contact number". If you
are viewing this thread from outside the UK, and dont have the leading
0, it works like this.

All non and geographical numbers in the UK (thats is everything except
soem services/operator services) have a leading 0. ie 0800 801 801.

I would like to use my database throuh a dialer, for purposes of
contacting my clients, so I need to include a 0, and make sure there
are no spaces between the numbers (if possible) how do I do this?

As i dont get to visit this site often, would you kindly post to my
email address regards

Adam


--
doktor_man
------------------------------------------------------------------------
doktor_man's Profile: http://www.excelforum.com/member.php...o&userid=34229
View this thread: http://www.excelforum.com/showthread...hreadid=539835

Looking to add a leading 0 @ start of numbers
 

If you've entered your contact number as text, you could use a helper column of
cells with formulas like:

="0"&a1

If you've entered the contact number as a number, maybe you could just change
the format of those cells to include another leading 0.

Or use a helper column of cells to convert it to text:

=text(a1,"0000....rest of format here")



doktor_man wrote:

Greetings all.

I have a database of contact details, and I am now looking to add a
leading 0 to the beginning of my data field "contact number". If you
are viewing this thread from outside the UK, and dont have the leading
0, it works like this.

All non and geographical numbers in the UK (thats is everything except
soem services/operator services) have a leading 0. ie 0800 801 801.

I would like to use my database throuh a dialer, for purposes of
contacting my clients, so I need to include a 0, and make sure there
are no spaces between the numbers (if possible) how do I do this?

As i dont get to visit this site often, would you kindly post to my
email address regards

Adam

--
doktor_man
------------------------------------------------------------------------
doktor_man's Profile: http://www.excelforum.com/member.php...o&userid=34229
View this thread: http://www.excelforum.com/showthread...hreadid=539835

--

Dave Peterson