Posted by toffee on 12/18/06 22:09

Hi all,

I created a little button which when clicked will run a query on mysql db
and output the results as an excel spreadsheet.
I do this by setting the header as application excel. All works well except
for a very strange problem. Let's say a column should say 16500.22. When I
run it here from the uk, the cell will show 16500.22
When someone in Netherlands runs it, the cells shows 16,500,220,000

It looks like Excel is mixing the commas and dot somewhere along the line ?

Anyway know what I can do to keep my colleagues from holland happy ?

Many thanks

T

[Back to original message]