Save as spreadsheet issue
Good day, I have a report and one of the columns collects serial numbers, the serial numbers are 24 characters long. There are over 6000 entries. Every time anyone tries to use the Save to Spreadshe...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendA suggestion is to create a formula field in the format
"SN: " & [serial]
The it will export as text. But the users may need to use a formula in excel if they need to strip out the "SN:"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
"SN: " & [serial]
The it will export as text. But the users may need to use a formula in excel if they need to strip out the "SN:"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
So is the issue with quickbase or is with excel converting the field to something else? I can't have the client going into the import/export section to download.
------------------------------
Mr Delemar
------------------------------
------------------------------
Mr Delemar
------------------------------
- MarkShnier__YouI think it is an excel issue. Excel sees a big number and converts it to scientific notation.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
