Forum Discussion

JamieBrown's avatar
JamieBrown
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
EverettPatterso's avatar
EverettPatterso
Qrew Captain
6 years ago
Make a formula text field and use that on the report you want to Save as Spreadsheet

formula text - combine single quote with original account number
"'" & [Textfield]​


If you add a single quote to beginning of the text string that contains a number, Excel will show the leading zeros




------------------------------
Everett Patterson
------------------------------
Related Content