I have a variable with type currency

Lets use the number 100

If left alone i get 100 (ie no Format() )

Format(strqrEquals, "$#,##0.00")Then this results in 100

Format(strqrEquals, "€#,##0.00")This gives a type missmatch error. I thought this is what I really wanted as I am in an Euro Country.

Could someone please assist me.

edit: Sorry I have posted this in the wrong place. Please move