Looking to add a leading 0 @ start of numbers

[doktor_man]

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 [email protected] regards

Adam

[Dave Peterson]

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 [email protected] 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