admin管理员组文章数量:1322018
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, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论