Request data in a specific format in web query

Hi,

I have a excel web query which pulls data from the web(My web application). Currently as we roll out our product to different locales, I am having issues while fetching data in different locales.

When my excel is refreshed in a french locale, I need to provide the numbers in my html table in french format. i.e. if the excel file is refreshed from a system whose language settings is fr_FR, my web application should render numbers in french format. i.e. 1,0233.2 should be rendered as 1 0233,2.

But if the same excel file refreshed from a system whose language settings is en_US, my web application should render numbers in english format. i.e. 1,0233.2 should be rendered as 1,0233.2.

I tried to check the locale in the http request in both cases and both are sending the locale as en_US; probably because excel is using the default browser's locale (and not the system locale) while sending the request.

Appreciate any help in this regard.

Thanks--