MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by RAY on February 15, 2002 2:57 PM

You mentioned in the weekly tip dated 9/23/99(tip 023), that "there were no instances were the leading zero of the phone number would be lost when joining area codes and telephone numbers because they do not start with zero, when concatenating". What would happen if they did start with zero? And could the zero's be recovered since they drop off during the concatenation process? I am battling with this as we speak and could use a little insight.

Posted by Dave on February 15, 2002 9:42 PM

telephone and like numbers can be recorded as

024 0000 0240000 =A2&B2

What is the actual problem that you are
trying to solve?

> I am battling with this as we speak and could use a little insight.

Posted by Laney Hayes on April 26, 2002 2:55 PM

There is only one way to keep that zero in the cell .. (I THINK, don't hold me to this hehe)

Type in ' before you start typing in the cell. Any time you do that it will automatically KEEP anything you put in that cell exactly as you typed it.

You should not ever have a phone number that begins with a Zero. There are no such phone numbers.

If you're just using extensions inside a company, none of the extensions should start with a 0, 9, or a 1. Pranksters call in and ask you to transfer them to a certain extension ...

1. If it begins with a 0 you're giving them a free international call to anywhere overseas.

2. If it starts with a 9 you're giving them an outside line in most businesses because you have to dial 9 to get out.

3. If it begins with a 1 you're giving them a free long distance call in the states.

Now if it's just for billing purposes, just use the ' in the cell when you start typing. It will keep anything you type in that cell, without change.

Hope that's what you were asking. If not, sorry. :) Let me know ...