Forum Discussion

Qrew Trainee

6 years ago

"save as spreadsheet" erasing my leading zeros

I have a Text field that contains numeric account numbers that generally start with Zero (ie: 04201345). They show fine in Quickbase, but when i "Save as Spreadsheet", the account number field alwa...

Data import and export

BabiPanjikar

Qrew Assistant Captain

6 years ago

Hi Jamie,

This is a excel behaviour and not a quickbase download issue. Do not double click the csv file directly to open in excel. This will trim the trailing zero and treat it as number instead of text.
Try this one. close the excel and open again. Open the file using menu-file-open file, locate your csv and the open.

------------------------------
Babi Panjikar
------------------------------