vba - Excel 365 Custom short number formatting (K, M, B, T,...,Q,D) - Stack Overflow

admin管理员组

文章数量:1328974

I would like to custom format large numbers up to 10^102 in Microsoft Excel pretty much the same as here.

Array formula suggested there felt the most convenient, but the issue is that I can't get the same result with virtual array solution {{},{}} in Microsoft Excel.

I don't know how to adjust that array function so it would work the same as it does in google sheets. .png

in google sheets below function spills 34:2 array when pasted by itself in a cell while in Microsoft Excel it would return "There's a problem with this formula." warning.

 =INDEX({{10^SEQUENCE(34, 1, 3, 3)}, 
 {"K  "; "M  "; "B  "; "T  "; "Qa "; "Qi "; "Sx "; "Sp "; "O  "; "N  "; "D  "; "Ud "; 
  "Dd "; "Td "; "Qad"; "Qid"; "Sxd"; "Spd"; "Od "; "Nd "; "V  "; "Uv "; "Dv "; "Tv "; 
  "Qav"; "Qiv"; "Sxv"; "Spv"; "Ov "; "Nv "; "Tr "; "Ut "; "Dt "; "Tt "}})

本文标签： vbaExcel 365 Custom short number formatting (KMbT