Formatting cell for phone numbers

C

Craig

I am trying to format a cell with phone numbers so that it will look
like the following:

(937) 123-3456
(937) 129-9876 fax
or
(937) 123-3456

The word 'fax' is more specifically a label, not necessarily that
word. I would like to have carriage returns between the numbers with
the possibility of several numbers. This may be confusing and/or too
complicated, but I'd like to give it a try. If anyone as suggestions
or possible solutions, I would appreciate hearing them.

Thanks,

Craig
 
R

RNelson

-----Original Message-----
I am trying to format a cell with phone numbers so that it will look
like the following:

(937) 123-3456
(937) 129-9876 fax
or
(937) 123-3456

The word 'fax' is more specifically a label, not necessarily that
word. I would like to have carriage returns between the numbers with
the possibility of several numbers. This may be confusing and/or too
complicated, but I'd like to give it a try. If anyone as suggestions
or possible solutions, I would appreciate hearing them.

Thanks,

Craig
.
Click to expand...
Hi Craig,

Not sure if this is the best way, but it works:

Format, Cells, Number, Category: Custom, Type: (###) ###-
####. You'll still have to enter them with the ('s and -
's. To enter more than one "row" per cell, use
<Alt><Enter> together to get each new row per cell

HTH
 
Top