Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Avoid duplicate number entry when only start and stop numbers given. | Excel Discussion (Misc queries) | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
Sorting alphanumeric numbers | Excel Discussion (Misc queries) |