Number in worksheet created in PHPExcel.

Topics: Developer Forum, User Forum
Aug 15, 2013 at 3:44 PM
I'm from Italy and i'm using Excel 2007 Italian Version and PHPExcel (last distribution).

This is the problem. When i try to create a new Excel Sheet loading data from a Database where number are stored without any format. Excel open the Sheet with numbers in the English notaion. (eg. 1,501.25 instead italian notaion 1.501,25) and there is no way to change this situation. I checked also Excel configuratione and all seem to be corrected. It uses System Separator and, of course i'm using Italian Version of Windows.

Thanks to everybody can help me.
Aug 19, 2013 at 1:02 PM
When you write your numbers in the Excel file, you give them a format?
As far as I know, the 'General' (the default) format does not include the thousands separator.
Very few exceptions, the formats are written in their English form in the file, Excel does conversion at the opening of the file taking account of regional settings.