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

DonLarson

Qrew Elite

6 years ago

Jamie,

This is very frustrating and is a Microsoft problem not Quick Base. You need to import the .csv into a workbook.

Then you will need to transform the data column to Text to get the prevailing zeros.

It is a real pain.

Don

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------