Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMATING PHONE NUMBER!!
In Range("H2") is a 10-digit number. How do I format the cell to show
the number in the format ###-###-####. Example: Entering 1478942266 should convert to 147-894-2266. Any help would be appreciated! Jay *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMATING PHONE NUMBER!!
Select Format/Cells from Excel's menu bar, select the Number tab on the
dialog box that comes up, select Custom from the Category list and then put this into the Type field... 000-000-0000 -- Rick (MVP - Excel) "jay dean" wrote in message ... In Range("H2") is a 10-digit number. How do I format the cell to show the number in the format ###-###-####. Example: Entering 1478942266 should convert to 147-894-2266. Any help would be appreciated! Jay *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMATING PHONE NUMBER!!
Select the column or the cells. Right click--Format Cells-- Custom..Type
text box enter the below ###-###-#### If this post helps click Yes --------------- Jacob Skaria "jay dean" wrote: In Range("H2") is a 10-digit number. How do I format the cell to show the number in the format ###-###-####. Example: Entering 1478942266 should convert to 147-894-2266. Any help would be appreciated! Jay *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMATING PHONE NUMBER!!
If you are looking for VBA use FORMAT
Msgbox Format("1234567890","###-###-####") If this post helps click Yes --------------- Jacob Skaria "jay dean" wrote: In Range("H2") is a 10-digit number. How do I format the cell to show the number in the format ###-###-####. Example: Entering 1478942266 should convert to 147-894-2266. Any help would be appreciated! Jay *** Sent via Developersdex http://www.developersdex.com *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMATING PHONE NUMBER!!
Thank you, Rick and Jacob Skaria !
It works !! Jay *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert number to phone number | Excel Discussion (Misc queries) | |||
Phone number not | Excel Discussion (Misc queries) | |||
LOOKUP a phone number? | Excel Worksheet Functions | |||
Formating phone numbers in cells | Excel Discussion (Misc queries) | |||
Phone number | Excel Discussion (Misc queries) |