R
Ron.Lencioni
I am working on globalization of a web app and running into a problem
that seems to be not all that common.
I have currency values in Culture A and our site exports the data to
excel. I give excel the format string for the Culture A i.e. "\#\,\#
\#0\.00\\ \[$€-40C\]\;\\-\#\,\#\#0\.00\\ \[$€-40C\]" (French). The
user using our application could be in US Culture which uses a
different currency format. I then format the currency value string to
French culture (12500,5) Which results in the number 12500,0 showing
up but not formatted with the French format. When the users culture
is in French and some other cultures such as Greek it will get
formatted properly.
My goal here is to give excel a format for the currency I want
displayed and give the number in that format and have it displayed in
that format. Example: If I have a French currency and user is any
other culture excel shows the currency in French format Euro.
Any help is appreciated
that seems to be not all that common.
I have currency values in Culture A and our site exports the data to
excel. I give excel the format string for the Culture A i.e. "\#\,\#
\#0\.00\\ \[$€-40C\]\;\\-\#\,\#\#0\.00\\ \[$€-40C\]" (French). The
user using our application could be in US Culture which uses a
different currency format. I then format the currency value string to
French culture (12500,5) Which results in the number 12500,0 showing
up but not formatted with the French format. When the users culture
is in French and some other cultures such as Greek it will get
formatted properly.
My goal here is to give excel a format for the currency I want
displayed and give the number in that format and have it displayed in
that format. Example: If I have a French currency and user is any
other culture excel shows the currency in French format Euro.
Any help is appreciated