Thousand format


I have the issue to change the line item format from 1,000,000 to 1,000 k. It's clear how to add "k", but how decrease the value to 1,000 without dividing? I mean it will be great to find the way how to change format, but not change the value. Thanks!

Best Answer

  • Ellen.Morley
    Answer ✓
    In the line item format, set the Thousand separator to "Dot".   This European style may give you what you need.