..

[ArxBzFhblxphS]

Edited February 5, 2010 by Thanubis

[Malkey]

I'm getting better at it, but I still don't fully understand StringFormat().

I know that StringFormat("%.2d", 8.8) will produce '08'.

I also know that StringFormat("%.2f", 8.8) will produce '8.80'.

What i want to know is, how do I combine the two formats to get '08.80'?

In the example "%05.2f":-

"0" means to add leading 0's to make up total number of characters ( in this case is 5 or 6);

"5" or "6" is the total number of characters including the decimal point;

".2" is the precision or number of decimal places.

MsgBox(0, "Result", ' StringFormat("%05.2f %06.2f", 8.8, 8.8) = ' & StringFormat("%05.2f %06.2f", 8.8, 8.8))

Edited January 31, 2010 by Malkey

[Bowmore]

This should do it. 5 is the minimum number of characters to output including the decimal poit.

$formatted = StringFormat("%.2f", 8.8)

Edit: Too slow at typing again

Edited January 31, 2010 by Bowmore