display USA phone format in formula bar
"Stephen S" wrote:
Excel 2003
I have lists of phone numbers in continuous 10 digits format. I'd like to
convert them to USA format so I can import them (with area code in
parentheses etc) into a PTA school phone directory using Word 2003 merge. I
know about Format/Cells/Special/Phone Number but this is obviously only for
display and printing purposes. While the cells show the US format, the
unformatted 10 digits are still in the formula bar.
|