When I run the following
VB Code:
Print Format("98765432111","(###) ###-####")
The answer is :
(9876) 543-2111
I want it to return:
(987) 654-32111
Is there any way to do it?
Please help.
Thanks.
Printable View
When I run the following
VB Code:
Print Format("98765432111","(###) ###-####")
The answer is :
(9876) 543-2111
I want it to return:
(987) 654-32111
Is there any way to do it?
Please help.
Thanks.
Try
VB Code:
Print Format("98765432111","(000) 000-0000")
Figured it out myself.
Thanks for trying
VB Code:
Format("98765432111","!(@@@) @@@-@@@@ @@@@@@@@")
No probs - thanks for the answer - I have learned something myself there.
The exclamation mark does the trick.
But it seems to work only with the @ placeholder.