Format problem : "Text" & Number; Number -> Standard format. How?

Hi,

Access Version 97 eng. under WinNT4

I have a report which will be printed and send to newspapers and have a
problem with a field where in some cases a text needs to be added to a
number. The number (EUR amount) should be shown in Standard format with 2
decimal places, e.g. 1.234,45 (Thousands Point, Decimal Comma)

I tried to add the Format(Number, "##.##0,00") in a query on which the
report is based on and in the Report itself but get either only e.g. 60 and
10,9 or an error from the formula - asking me when running the report for a
value for Format.

Field Type of Number is double - I don't want to change it to currency as I
don't want to have the currency symbol in the field.

Last but not least the used formula in the report:
=IIf([Ratio]1;IIf(Int([Ratio])[Ratio];"In Addition " &
[Amountrounded];[Amountrounded]);[Amountrounded])

(Semicolons in the formula above are due to regional settings = German
Standard)

Any Suggestions how to solve this?

--
TIA
Bernd