I what way is it not what you want? Did you read the documentation on formatting cells? I think you want something like this:

my $format = $workbook->add_format(align => 'left');
$worksheet->write_number(0, 0, 23.25, $format);
[download]