number data Display Format #.####,##

I use the macro reference "number data" and want to add several sums. But we would like to keep our spelling of the numbers. That means: We write 1.000,11 Euro and the "American" spelling would be 1,000.11 Euro. Say "," and "." are reversed. What do I have to enter in format (Display Format)? #.####,## instead of #,####.## ?

  • Guest
  • Nov 4 2019
  • Needs review
Hosting platform Server
  • Attach files