I was seeing the same thing with Spreadsheet::XLSX. For other reasons (built-in number/date formats not handled) I switched to Spreadsheet::ParseXLSX. With the latter, cells with built-in 'custom' number formats have correct formatted values and the entities are processed back to characters.