Forum Discussion

MikeTamoush's avatar
MikeTamoush
Qrew Commander
7 months ago

Keep Trailing Zeros on CSV Export

When i download a report as a csv, if there is a number field it will dissappear the trailing zeros. So for example:

5000.10 downloads in the csv as 5000.1.

This seems to be due to the fact that it marks the column as type 'General' in Excel. When a column is that type, it deletes trailing zeros.

I have found that if I make it a currency in Quickbase, or text (include alpha), the csv will select type text or currency (currency keeps the trailing 0, but of course has the dollar sign - this may be a work around, I haven't tried).

If the excel type is selected as 'number' it also keeps the trailing zero, but I cannot figure out anyway for the csv export to label numbers, as numbers (they get labeled as general).

Has anyone figured out a trick to download a csv, and keep trailing zeros?

No RepliesBe the first to reply