Formatting cell for phone numbers

  • Thread starter Thread starter Craig
  • Start date Start date
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
 
-----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
 
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
Click to expand...

That is partially what I'm after. I also would like to be able to enter text following the phone number. For example:
enter; 9371234567 fax
results: (937) 123-4567 fax

If that is possible, I'd like to take it one step further so that I could enter numbers on two lines, possibly with a label, and each number would be formatted correctly. Ex:
enter: 9371234567 (alt+enter)
9874569874 fax
result (937) 123-4567
(987) 456-9874 fax

Hope that was clear. I may be asking too much, but if possible, I would like to try it.

Craig
 
Back
Top