MustangPriMe
IS-IT--Management
I'm trying to export a table of data to excel, for two languages, using ASP output in an HTML format.
For English users, it's fine. In the output I see ...<TD>123.45</TD>... and excel recognises it as a number which can be summed etc.
For French users, the output correctly shows ...<TD>123,45</TD>... using a comma as the decimal point, but when their excel opens the file it is not recognised as a number but text. Summing operations therefore fail.
Is there a reason or workaround for this?
Thanks
Paul
For English users, it's fine. In the output I see ...<TD>123.45</TD>... and excel recognises it as a number which can be summed etc.
For French users, the output correctly shows ...<TD>123,45</TD>... using a comma as the decimal point, but when their excel opens the file it is not recognised as a number but text. Summing operations therefore fail.
Is there a reason or workaround for this?
Thanks
Paul
