I used the FormatCurrency function and it works fine. I do have two questions though.

1. It now displays the $ sign and I want it to be €.

2. As I understand the FormatCurrency function will show the currency that the local computer has set as standard. Does that mean that anyone using my website will get a different currency? So if someone from the US logs in all amounts will be in $ (dollar)and someone from say EEC will get €(Euro)?

Check out the setlocale function.