Log In
Register
Home
May 27, 2014
Offline
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
See Answer
VIP
April 21, 2015
Offline
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!
May 27, 2014
Offline
(The custom format between the quotes)
Format "#,#.K" turns 7200 to 7,2K and the point is to turn to 7.2K
Format "#.#,K" turns 7200 to 7.200,K
Thanks Visser
Miguel
VIP
April 21, 2015
Offline
OK, good you figured it out for your settings.
Strange is: here it is the other way around! So must have to do something with localised settings of Excel? I use the Dutch language version of both Windows10 and Excel.
So here it works as follows:
But anyway you now know how to fix it!
Answers Post
1 Guest(s)
