Re: Writing a number to a cell using Spreadsheet::WriteExcel

Try the format '00000000'.

rdfield

Comment on Re: Writing a number to a cell using Spreadsheet::WriteExcel

Replies are listed 'Best First'.
Re: Re: Writing a number to a cell using Spreadsheet::WriteExcel by ColtsFoot (Chaplain) on Oct 25, 2002 at 10:16 UTC
rdfield, Your a star, $format->set_num_format('00000000'); worked just fine Did I miss it in the doc ?	[reply]
Re: Re: Re: Writing a number to a cell using Spreadsheet::WriteExcel by rdfield (Priest) on Oct 25, 2002 at 10:46 UTC
You're welcome. The format was derived directly from the examples in Excel's "Format Cells..." dialog. rdfield	[reply]