LinkBack URL
About LinkBacks
PHONE formatting. Is there a way to create a macro to format the VALUE of the phone to be either (XXX) XXX-XXX or XXX-XXX-XXXX ??? I obviously can get it to look like this, but the value is just XXXXXXXXXX.
Thanks much in advance!!!
PHONE formatting. Is there a way to create a macro to format the VALUE of the phone to be either (XXX) XXX-XXX or XXX-XXX-XXXX ??? I obviously can get it to look like this, but the value is just XXXXXXXXXX.
Thanks much in advance!!!
Good afternoon jreimer
You don't need to use a macro - just use a custom format.Originally Posted by jreimer
Select your cell / range.
Press Ctrl + 1.
On the number tab, goto Custom in the Category box and type one of the below into the box marked Type :
(###) ### ####
###-###-####
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
that gives me the same issue - it looks correct, but the value is still XXXXXXXXXX.
Hi jreimer
If it looks correct then what's the problem? Can you elaborate?
DominicB
the value of the cell is still XXXXXXXXXX not (XXX) XXX-XXXX - the format is just (XXX) XXX-XXXX - so it looks all nice and pretty, but the value of the cells is not the same.
In the cell - it looks like (XXX) XXX-XXXX, but if you click on the cell, in the bar to edit its contents - its XXXXXXXXXX (incorrect).
Hi jreimer
OK. Highlight the range you want to address and then run this macro :
Note, you can change the ###-###-#### to (###) ### #### to suit whichever format you prefer.
Sub test() For Each UsrRnge In Selection UsrRnge.Value = Application.WorksheetFunction.Text(UsrRnge.Value, "###-###-####") Next UsrRnge End Sub
HTH
DominicB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks