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