Hi:

How do I format cells for entry of USA Telephone Numbers, as:     1 (###) ###*-*####
whenever, for example,I have typed a ten-digit number, e.g., 1234567890 
(no spaces, no negative/minus sign, no parenthesis, by use of the number 
keypad (NumLk is enabled).
Yes, I want the "1" prefix, the area code to appear within parenthesis, 
and a negative/minus sign between the 3rd digit and the 4th digit. A 
space follows the prefix "1" and a space follows the closing parenthesis.
I have tried to set a user defined number-format, but am getting strange 
results with apostrophes and/or double quote markings mixed in when 
viewing the Format Cells dialogue, e.g., (#") "###"*-*"####. And, I 
don;t understand why that is. I was hoping to find a pre-defined/default 
format for use when entering USA telephone numbers. I am flexible; I can 
probably do without the "1" prefix and/or the parenthesis.
Should I be formatting these cells as "text" (left-justified) rather 
than as numbers (right-justified)?
Regards,

VinceB.

Reply via email to