use strict; use warnings; use diagnostics; use Win32::OLE; my $xl = Win32::OLE->new('Excel.Application'); $xl->{Visible} = 1; $xl->Workbooks->Add; my $rng = $xl->Workbooks(1)->Sheets(1)->Range("A1"); $rng->{Value} = 200; $rng->{NumberFormat} = "0000"; $rng = $xl->Workbooks(1)->Sheets(1)->Range("A2"); $rng->{Value} = "'0200";