trevorbranton
New Member
- Joined
- Apr 8, 2010
- Messages
- 3
Hi All
First of all, if this has already been posted and resolved, SORRY!. I could not find it when searching.
My question is quite simple, yet, I cant find an answer/solution as yet.
I wish to enter a phone number in to excel (using 2007 version) in the following way, (01234) 456789 (5 digits for area code and 6 digits for number) - I have figured out that the format to use is something like '(0####)_######'
However some locations where I live still have a 5 digit phone number and therefore I will need to have the facility to have a number like (01234) 56789 (5 digits for area code and 5 digits for number)
My problem is that what ever combination of codes I try, I end up with a mess Its the occasional 10 digit combination is the route of the problem and would love to see if I can overcome this.
Any suggestions or help would be greatly appreciated.
Thanks
First of all, if this has already been posted and resolved, SORRY!. I could not find it when searching.
My question is quite simple, yet, I cant find an answer/solution as yet.
I wish to enter a phone number in to excel (using 2007 version) in the following way, (01234) 456789 (5 digits for area code and 6 digits for number) - I have figured out that the format to use is something like '(0####)_######'
However some locations where I live still have a 5 digit phone number and therefore I will need to have the facility to have a number like (01234) 56789 (5 digits for area code and 5 digits for number)
My problem is that what ever combination of codes I try, I end up with a mess Its the occasional 10 digit combination is the route of the problem and would love to see if I can overcome this.
Any suggestions or help would be greatly appreciated.
Thanks
