[RESOLVED] Comma Formatting of number with leading Zeros removed

[Signalman]

I currently have a number that I want to display with comma's between the thousands. I have found in the documentation that I can format it using ToString("0,000,000")

if the number is 7654321, it correctly displays it as 7,654,321

However if the Number is just 4321, it display it as 0,004,321

Looking at the documentation, I can't find a formatting option to remove the leading zero's so that 4321 would be displayed as 4,321.

Without testing the length of the string and specifying a format depending upon the string length, is there a formatting option that removes the leading Zeros' ?

[PlausiblyDamp]

ToString("#, ##0") should do the trick

[Signalman]

That's Great Thanks. Works Perfectly.

[.paul.]

Try...

Dim number as decimal = 123456.00
MsgBox(number.ToString("n0")) ' = "123,456"

If you need 2 decimal places...

Dim number as decimal = 123456.789
MsgBox(number.ToString("n2")) ' = "123,456.79"

[Signalman]

Excellent, thanks .Paul