Named Format equivalent to the FormatNumber function

[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.

 

[Guest]

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

 

[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.

Try just using #.

John W. Vinson [MVP]