Forum Discussion
MarkShnier__You
Qrew Champion
The field type needs to be formula text because it has leading zeros and trailing zeros.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
JamieStrauss
11 months agoQrew Member
Mark! Worked like a charm!! Thank you so much! Now, any ideas on how to export it so excel doesn't drop all of the zeros?
------------------------------
Jamie Strauss
------------------------------
- MarkShnier__You11 months agoQrew Champion
I don't know a way to have the Excel CSV open up and maintain the leading zeros. The only way I caan think of would be to change the last line to this
"#" & $FirstFour & $LastFive
Then Excel would see that as a text string. Any non numeric value in the string will cause Excel to treat it as text - there is nothing special about using an #.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- JamieStrauss11 months agoQrew Member
Thanks Mark! And my team thanks you too! :)
------------------------------
Jamie Strauss
------------------------------