topic-29104

Posts: 582

Joined: Fri Oct 07, 2005 02:17 PM

Cells format in Excel 2013, Mr Rao ??
Posted: Wed Aug 20, 2014 02:23 AM

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

Enrrique Vertiz Pitta

Lima-Peru

xHb 1.23.1026X, Fwh 25.01, BCC74, MySQL 8.0.X, SQLLIB 1.9m

anserkk

Posts: 1335

Joined: Fri Jun 13, 2008 11:04 AM

Re: Cells format in Excel 2013, Mr Rao ??
Posted: Wed Aug 20, 2014 04:50 AM

Please try

Code (fw): Select all Collapse

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

Posts: 582

Joined: Fri Oct 07, 2005 02:17 PM

Re: Cells format in Excel 2013, Mr Rao ??
Posted: Wed Aug 20, 2014 05:16 AM

Thank you

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

Thank you very much

Enrrique Vertiz Pitta

Lima-Peru

xHb 1.23.1026X, Fwh 25.01, BCC74, MySQL 8.0.X, SQLLIB 1.9m

Gale FORd

Posts: 663

Joined: Mon Dec 05, 2005 11:22 PM

Re: Cells format in Excel 2013, Mr Rao ??
Posted: Wed Aug 20, 2014 02:14 PM

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

Posts: 582

Joined: Fri Oct 07, 2005 02:17 PM

Re: Cells format in Excel 2013, Mr Rao ??
Posted: Wed Aug 20, 2014 06:00 PM

Buena idea Gale, voy a probar, gracias

Enrrique Vertiz Pitta

Lima-Peru

xHb 1.23.1026X, Fwh 25.01, BCC74, MySQL 8.0.X, SQLLIB 1.9m

FiveTech Support Forums

Continue the discussion