yogi_Set Up Custom Number Formatting To Show T for Trillion B For Billion and M For Million

Google Spreadsheet   Post  #2333

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

question by: SharkSheaker

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

formatting of numbers not working

i want to realize to replace numbers like E3,E6,E9... with K,M,B...

i tried this formula: [>999999999]###.0,,," B";[>999999]###.0,," M"

adding a new case: [>999999999999]###.0,,,," T";[>999999999]###.0,,," B";[>999999]###.0,," M"

second line isnt working

can someone tell me why and help me to fix it.