Tuesday, November 21, 2017

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

No comments:

Post a Comment