currencies always have an extra .0

[Ir1e]

For some mysterious reason my currencies always look like this:

20.0.00 for 20 Euros

withe the last two 00;s are the decimals

I just can't find a way to remove the .0!

please help!

[Olly]

What is the number format applied to the cell?

[Ir1e]

??? you mean....

currencies.... ???

Euros...

2 decimals ???

I didn't set it to numbers? those are working fine

[Ir1e]

can anybody help?

[Olly]

Perhaps you can attach a workbook, so we can see the numberformat you are referring to.

[Ir1e]

Ok here it is.

Thanks for your help

[Olly]

Okay, your cell A1 has a custom numberformat, as: "€" #.##0.00 As you can see, this format includes two decimal points, hence your error.

Do you use , or . as your thousand separator / decimal point? For UK settings, the required number format would be: "€" #,##0.00 but your locale requirements may be different. Either way, you need to change the cell numberformat so that it doesn't include two decimal points.