in reply to Writing a number to a cell using Spreadsheet::WriteExcel

Can't say that I know the module but it looks as if it's just taking the number without applying the formatting. You could try sprintf - something like:

$wb->write($i, $j, sprintf("%08d", $item), $format);

UPDATE: I was going to say try a format of "00000000", but rdfield beat me to it

Hey, if there's code up ^^ there ^^, don't blame me if it doesn't work.

But today you took me walking, Through a land that we have lost,
While our children sit at websites, With no access to the cost