Cells format in Excel 2013, Mr Rao ??

[Enrrique Vertiz]

Greetings ...

I have a problem creating an Excel file with Office 2013, I have no problem with previous versions, in all previous cases put the following line:

oSheet: Cells (NFIL, 6): NumberFormat: = "#, ## 0.00"

And I format the cell with "," as thousand separator, with "." as decimal point and 2 decimal digits, but in Office 2013 I do not respect that format and I placed the numbers "without" thousands separator and 3, 4-5 decimal ...

Anyone have any idea how to fix it, thank you very much

[anserkk]

Please try

Code: Select all  Expand view

oSheet: Cells (NFIL, 6): NumberFormat:      = "#, ## 0.00"
oSheet: Cells (NFIL, 6): NumberFormatLocal: = "#, ## 0.00"

I don't think it is due to the MS Office version. May be the the locale settings on your PC and the thousands separator and the decimal separator.

I haven't tested it personally.

Regards
Anser

[Enrrique Vertiz]

Thank you

I check the configuration of the PC, but proves again with your indication.

Thank you very much

[Gale FORd]

When I have a question like this.
I record a macro, set the format I want, stop macro recording, then edit the macro and check out what Excel thinks it should be.

[Enrrique Vertiz]

Buena idea Gale, voy a probar, gracias