Format Column for Telephone Numbers

Ludovico · May 20th, 2002, 08:19 AM

I'm sure this has been asked before but can't seem to find with search .....
I have a long column of telephone numbers like so: 314 6666666, which I want to show like so: 314 666-6666. Tried selecting the column and applying the "Custom" format:
###_###-####

and the "Special" format "Phone Number"
Neither has any effect.
What am I doing wrong?
Thanks.

Robin · May 20th, 2002, 08:25 AM

Not sure what the problem with the formats but if your number was in A1 then you could try:

=left(a1,3)&" "&mid(a1,5,3)&"-"&right(a1,4)

sann0638 · May 20th, 2002, 08:28 AM

Hi Ludovico,
putting the space in the original number makes the number into a text field. If you remove the spaces, you can format at will!

Rgds,
Mike

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 08:19 AM	#1
Ludovico Board Regular Join Date: Apr 2002 Posts: 66	I'm sure this has been asked before but can't seem to find with search ..... I have a long column of telephone numbers like so: 314 6666666, which I want to show like so: 314 666-6666. Tried selecting the column and applying the "Custom" format: ###_###-#### and the "Special" format "Phone Number" Neither has any effect. What am I doing wrong? Thanks.

May 20th, 2002, 08:25 AM	#2
Robin New Member Join Date: Feb 2002 Posts: 16	Not sure what the problem with the formats but if your number was in A1 then you could try: =left(a1,3)&" "&mid(a1,5,3)&"-"&right(a1,4)

May 20th, 2002, 08:28 AM	#3
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	Hi Ludovico, putting the space in the original number makes the number into a text field. If you remove the spaces, you can format at will! Rgds, Mike