

May 27, 2014

Using custom number format, how is it possible to scale the number 7.200 to 7.2K
Note: I'm european (portuguese) so the thousand is represented by a . (period) and the decimals by , (comma)
The format 0,0.K turns 7.200 to 7,2K which can be misleading.
Thanks,
Miguel

VIP

April 21, 2015

Tricky one, but in your case it is: '#,#.K' (the custom format between the quotes).
It's kind of contra-intuitive and I first used Mynda's page for this (https://www.myonlinetraininghu.....c474757753) but saw your question wasn't answered there.
Microsoft itself gave a hint on https://support.office.com/en-.....8;fromAR=1
But because that's the English/American version I changed the point and comma and that works!
1 Guest(s)
