LinkBack URL
About LinkBacks
Gary_Di 
Excel does not apply custom formatting to text. You will have to use a formula for your vehicle numbers.
=LEFT(A5,4)&"-"&MID(A5,5,LEN(A5)-8)&"-"&RIGHT(A5,4)
For the phone numbers use
+91 (000)000-0000
Excel does not apply custom formatting to text. You will have to use a formula for your vehicle numbers.
=LEFT(A5,4)&"-"&MID(A5,5,LEN(A5)-8)&"-"&RIGHT(A5,4)
For the phone numbers use
+91 (000)000-0000
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks