Thousand and decimal separators with Spreadsheet::WriteExcel

ganeshk has asked for the wisdom of the Perl Monks concerning the following question:

I beg your pardon for asking this. But after googling to some extent I couldn't find much and I am also in bit of hurry.

I want to know how to change thousand separator and decimal separator in Excel. I found that in MS Excel 2003 you can do this by changing the settings in Tools->Options->Internationalization tab.

But I just want to confirm that if this is some setting that is be done only on the excel tool and not on the worksheet itself or we can do this international setting on the spreadsheet also. And if it is possible in Excel how can we do it through from Spreadsheet::WriteExcel?

Thanks very much in advance for the help!!

Thanks,
Ganesh

Comment on Thousand and decimal separators with Spreadsheet::WriteExcel

Replies are listed 'Best First'.
Re: Thousand and decimal separators with Spreadsheet::WriteExcel by jmcnamara (Monsignor) on Aug 21, 2008 at 15:39 UTC
I just want to confirm that if this is some setting that is be done only on the excel tool and not on the worksheet itself That is correct. It can only be changed at the system or Excel level. It cannot be changed by an Excel file and hence cannot be changed by Spreadsheet::WriteExcel. -- John.	[reply]
Re^2: Thousand and decimal separators with Spreadsheet::WriteExcel by ganeshk (Monk) on Aug 21, 2008 at 15:59 UTC
Thanks very much for the reply. Thanks, Ganesh	[reply]
Re: Thousand and decimal separators with Spreadsheet::WriteExcel by olus (Curate) on Aug 21, 2008 at 15:23 UTC
Check cell formating on the documentation to see if it helps your intents. Perhaps `set_num_format` is what you are looking for.	[reply] [d/l]