I am in such a terrible bind right now because our financial department just received a heavily modified investor presentation from our global team, and the entire layout is completely broken due to decimal regional formats. In my local office, we use periods for decimals and commas to separate thousands, but the converted sheet has everything completely inverted, which makes our quarterly profit figures look like complete pocket change. I am terrified that if I do not fix every single one of these thousands of numerical cells manually before our Zoom call with the stakeholders tomorrow, we are going to look completely unprofessional. I desperately need to find a way to automate this translation checking process because doing this line by line is making my eyes bleed.
Forum