Named Format equivalent to the FormatNumber function

  • Thread starter Thread starter Bob Howard
  • Start date Start date
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.
 
You can use the number one as usual:
CStr(FormatNumber(CSng("123","whatever")))
Might lack efficiency...
 
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]
 
Back
Top