Named Format equivalent to the FormatNumber function

B

Bob Howard

Is there a named format that I can use in a Format function that gives the
same result as the FormatNumber function (uses the Windows Regional "Number"
Setting)?

i.e., what "?????" can I use so that =Format("123","?????") gives the same
result as =FormatNumber("123") ?

Bob.
 
S

Stwange

You can use the number one as usual:
CStr(FormatNumber(CSng("123","whatever")))
Might lack efficiency...
 
J

John W. Vinson

Is there a named format that I can use in a Format function that gives the
same result as the FormatNumber function (uses the Windows Regional "Number"
Setting)?

i.e., what "?????" can I use so that =Format("123","?????") gives the same
result as =FormatNumber("123") ?

Bob.
Click to expand...

Try just using #.

John W. Vinson [MVP]
 
Top