in reply to Re^2: Excel Formatting
in thread Excel Formatting

You are applying the currency format at the end, after you have written all the data? (before closing the file, of course).

Replies are listed 'Best First'.
Re^4: Excel Formatting
by PerlSufi (Friar) on Apr 22, 2013 at 20:54 UTC
    Yes. I have tried declaring 
    my $trans_format = $workbook->add_format();
$trans_format->set_num_format('$0.00');

    [download]
    where I set my other formats and after the while loop. I have also done $worksheet->set_column('I:I', undef, $trans_format); after the while loop. I can't figure it out..
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom