displaying currency

[jacobus]

howdy all,

I've got a small but annoying problem ..

I retrieve a currency value from a database.
If the value is, say 34.50 , only the number 34.5 is shown.
I've tried ccur() and round(x,n) but that doesn't work.

Somebody got an idea ?

thanks
jacobus

 

[onpnt]

use the formatcurrency function

Dim MyCurrency
MyCurrency = FormatCurrency(34.50)
' MyCurrency contains $34.50
I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.
admin@onpntwebdesigns.com

 

[jacobus]

Thanks onpnt.
The number is shown ok.
But now this...

On my computer (win98 dutch) currency is set to display in euros.
On the server (win2000 eng.) currency is set to display in euros.

However, using FormatCurrency displays a $ -sign !
Is it me or eh ...

 

[onpnt]

I would jsut do this then
dim Mymsg
money = "34.5"
money = FormatNumber(money,2)
' 2 in the FormatNumber function = 2 decimal places
Mymsg = msgbox(money)


Or I found this and you can do it on the select in the SQL statement

http://www.vbsdb.com/sources/pages/forum/topic.asp?TOPIC_ID=10

I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.
admin@onpntwebdesigns.com

 

[jacobus]

I'm going with the FormatNumber(x,n) one.
I'll keep the "format( UnitPrice , '##,##0.00')" for later.

Thanks again.
jacobus