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 (e-mail address removed) 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")