admin管理员组

文章数量:1330112

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

版权声明：本文标题：vba - Excel 365 Custom short number formatting (K, M, B, T,...,Q,D) - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1737085156a1961823.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。