How are you getting the value of the cell? If you use:

$cell->{Val}
[download]

then you will get the unformatted value, but if you use:

$cell->value()
[download]

you should get the formatted value