Search code examples
excelvbanumber-formatting

VBA formatting issue

I'm formatting a cell with the following format using VBA (€ accounting):

"_-* #.##0,00 €_-;-* #.##0,00 €_-;_-* ""-""?? €_-;_-@_-"

But strangely in Excel the numbers are shown as i.e. 50,05 is 50,05000€.

When I select format I get the following:

_-* #,##000 \€_-;-* #,##000 \€_-;_-* "-"?? \€_-;_-@_-

The commata in the zeros have gone missing. How do I fix this?

Thanks

Solution

  • I find the . strange in the left part.

    I would try something like "_-* # ##0,00 €_-;-* # ##0,00 €_-;_-* ""-""?? €_-;_-@_-"