Formula modifying an existing set up numbers
Hi Everyone, I have a formula I am trying to find but I'm losing hope. I need to remove a decimal in a string of numbers and reformat in a specific way. Regardless of the original length, I need to ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe field type needs to be formula text because it has leading zeros and trailing zeros.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
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__You
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
------------------------------Thanks Mark! And my team thanks you too! :)
------------------------------
Jamie Strauss
------------------------------