Exporting to Excel truncates number values

Exporting to Excel truncates number values

We have a table for tracking time. One of the fields is for hours. Hours are recorded to two decimal places (e.g. fifteen minutes is 0.25). When I downloaded the records in Excel format, all the numbers had been truncated and set as whole numbers. Fortunately I caught this before using the data for billing. (btw, using the CSV export preserved the decimals).

We're having problem after problem after problem with this software. It's definitely not something you should use for critical tasks.

(Note: I originally posted this -- accidentally -- under Zoho CRM. It belongs here, under Tables.)