yogi_Custom Number Format Cells With k M B T And Vice Versa

Google Spreadsheet   Post  #2294

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-21-2017

question by: SharkSheaker

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/0ehdquTrIlg;context-place=forum/docs

Transforming any number typed into a cell into a k,M,B,T... shortened
There are cells, for example cell A1, where a very high number can be typed into. now the number inside that cell should be formatted to k,M,B...

for example 25.300.000 would usually turn into 2,53E+7 but i want to have 25,3 M

when numbers have to many non zeros, the value is rounded up. for example 123.475.345.876 turns into 123,5 T

because:
k stands for kilo
M for million
B for billion
T for trillion
Q for quadrillion
Qi for quintillion

etc.

thank you for any help