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
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.myonlinetraininghub.com/excel-custom-number-format-guide#_Toc474757753) but saw your question wasn't answered there.
Microsoft itself gave a hint on https://support.office.com/en-us/article/Create-or-delete-a-custom-number-format-78f2a361-936b-4c03-8772-09fab54be7f4?ui=en-US&rs=en-US&ad=US&fromAR=1
But because that's the English/American version I changed the point and comma and that works!
(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
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!
