in reply to Perl reading excel spreadsheet getting ##### for few columns

Change it to Cells($whatever, $whatever)->{'Value'} and you'll get the real values instead of the displayed text.