(Reverse address to reply.)
"Chris Kennedy" <chrisknospamcybase.co.uk> wrote in message
news:eKOpTOieEHA.2396TK2MSFTNGP11.phx.gbl...functions.> I am pulling a decimal value from SQL server and trying to use the format
> currency and format number function. I am using these values in a large
> string of HTML to be used in a CDONTS Email. If I use the code fragment
> below the price variable, which is 3.92 in the database, shows up as £392.
> When the formatcurrency is removed it is displayed as 3.92 but!!!! if I
> concatenate a "£" it displays £392. I have read some posts about VBscript
> not liking decimals, are there any ways around this. I have tried a
> conversion to the money datatype, used a variety of csng and cdblformat> The odd thing is other numbers from the same column in the recordseta> correctly. The other thing is that variable 'price' is used elsewhere and
> calculates correctly it seems VBscript just doesn't like converting it to> string. Totally stumped!! Can anyone help.
> HTML = HTML & "<td>" & formatcurrency(price) & "(€" &
> formatnumber(price*rate,2) & ")" & "</td>"