Euro with 4 decimals - how to suppress ending Zeros

Question

Hi

I have a customer that need to set some prices with 4 decimals. Like 2.2354 Euro.
I know how to handle it. But the customerns normal price is like 2.20 Euro or 10 Euro.

I want to avoid figures on reports as 2.2000 € and 10.0000 € but want 2.2354 to be 2.2354 €

Cant figure it out.

Help needed.

---

Cheers // Peter Forss Stockholm

Answer 1

Hi Peter,

Try using other formats except Fixed.

Answer 2

Try the format

  0.00##

in the format property of the text box.

Matthias Kläy, Kläy Computing AG