Prev: Sell Your DynaZip Version 5
Next: VB6!
From: techman41973 on 27 Feb 2010 14:30
I need a function that converts a number to a comma deliminated number
similar to currency.
such as 533333 to 533,333 (basically adding in commas).
My application is to show the number of miles on a car (rather than
strict currency)

I tried the following function with experimenting changing the
VbFalse's to VBtrue's
no luck. I would appreciate some assistance. Thanks

myvar1 = FormatNumber(nm1, 2, vbFalse, vbFalse, vbFalse)

From: Martin Trump on 28 Feb 2010 11:54
techman41973 wrote:
> I need a function that converts a number to a comma deliminated number
> similar to currency.
> such as 533333 to 533,333 (basically adding in commas).

Debug.Print Format$(500001,"#,#")
500,001

HTH

Martin
 | 
Pages: 1
Prev: Sell Your DynaZip Version 5
Next: VB6!