最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

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

programmeradmin8浏览0评论

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 "}})

与本文相关的文章

发布评论

评论列表(0)

  1. 暂无评论