ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   custom telephone number format (https://www.excelbanter.com/excel-discussion-misc-queries/149846-custom-telephone-number-format.html)

[email protected]

custom telephone number format
 
I've forgotten............how do I format 1234567890

to 123 456 7890

Many thanks!!!

....Lisa


James Silverton[_2_]

custom telephone number format
 
wrote on Wed, 11 Jul 2007
13:22:42 -0700:

gl to 123 456 7890

gl Many thanks!!!

Wouldn't a custom format 000 000 0000 not work? I personally
prefer some sort of separator between the groups like "-" or "."
.. It tends to reduce mistakes even if things like (123) 456-7890
are a bit old fashioned in metropolitan areas where all 10
digits are always needed.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not


Toppers

custom telephone number format
 
Custom == 000 000 0000

" wrote:

I've forgotten............how do I format 1234567890

to 123 456 7890

Many thanks!!!

....Lisa




All times are GMT +1. The time now is 08:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com