StringFormat for currency

[geller]

I am trying to left-pad currency with blank spaces, and the following example does work, but it uses StringFormat twice. Is there a way to accomplish this with just one use of StringFormat? Thanks for any help.

ConsoleWrite(StringFormat("%10s", StringFormat("%#.2f", "123")) & @CRLF)

[BigDaddyO]

you could try this

ConsoleWrite(StringRight("          " & StringFormat("%#.2f", "123"), 10) & @CRLF)

 

[TheXman]

Another alternative:

ConsoleWrite(StringFormat("$%10.2f", 5) & @CRLF)
ConsoleWrite(StringFormat("$%10.2f", 50) & @CRLF)
ConsoleWrite(StringFormat("$%10.2f", 500.125) & @CRLF)

Output:

$      5.00
$     50.00
$    500.13

 

Edited March 4, 2020 by TheXman

[geller]

Your solution works perfectly. I just wish the string-format documentation was more detailed...

[Nine]

58 minutes ago, geller said:

I just wish the string-format documentation was more detailed...

You must read all the documentation carefully and look at the examples.  There are 10s of different formats shown in the example scripts.  Just open them and make some test.  But I suppose it is less demanding to ask here for help, right ?