I want to create a Excel for Web, which changes the currency format according to the regional settings of the logged in user.
So, when user Dan with regional settings Germany is logged in he should see € as currency. When Phill is logged in with regional settings United States he should see $ as currency.
I have already created an excel File with German regional settings. Maybe someone can open and verify with United States Settings that the formats are changing.
My settings and what I see in Excel:
