PHP/PEAR - Retain trailing zeros when creating spreadsheets

Question

I'm using the PHP PEAR package to generate excel spreadsheets. I have data of type double with trailing zeros that need to be retained. How can I preserve this data without having the Worksheet::writeNumber function truncate the zeros? I've tried changing the format string in the pack function but no luck yet.

Answer 1

Add a ' before it, e.g.

"'" . $number