Format Function Right To Left

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.