Dynamic format string numbers on export dont produce readable numbers for excel

DO NOT LINK ME TO IRRELEVENT ARTICLES PLEASE. My Format code used for my report is:   SWITCH(     true(),     SELECTEDMEASURE()>999999999,"€#,##0,,,.0B",     SELECTEDMEASURE()>999999,"...