hello,
how can I stop a number from looking like this:100.00103032?
I need to format it like $100.00
thanks
Printable View
hello,
how can I stop a number from looking like this:100.00103032?
I need to format it like $100.00
thanks
Use the format function.Code:msgbox format (100.00103032,"$0.00")
You can't use Format in VBScript.
Code:MyNumber = 100.00103032
MyCurrency = FormatCurrency(MyNumber, 2)
'MyCurrency contains $100.00
ah, my bad, didn't know that :(
thanks,
right after I posted I relized I didn't mention I was using VBscript.
thanks Monte96