ExcelBanter - is there a template for Excel for a telephone format?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - is there a template for Excel for a telephone format? (https://www.excelbanter.com/excel-discussion-misc-queries/47202-there-template-excel-telephone-format.html)

template request for telephones

is there a template for Excel for a telephone format?

It would be nice to be able to convert a 10 digit number so that it would be
readable as a telephone number such as (332) 233-8765. Excel in office 2000
is the program I use. Also Word in office 2000.

CyberTaz

FormatCellsCustom--Phone Number

Regards |:)

"template request for telephones" wrote:

It would be nice to be able to convert a 10 digit number so that it would be
readable as a telephone number such as (332) 233-8765. Excel in office 2000
is the program I use. Also Word in office 2000.

B. R.Ramachandran

Hi,

'Format' - 'Cells' (In the Toolbar), or select the cell(s), Right click
and select 'Format Cells'
Then, select under 'Number', 'Special' and 'Phone Number'

Regards,
B. R. Ramachandran

"template request for telephones" wrote:

It would be nice to be able to convert a 10 digit number so that it would be
readable as a telephone number such as (332) 233-8765. Excel in office 2000
is the program I use. Also Word in office 2000.

All times are GMT +1. The time now is 05:35 PM.