Forum Discussion

JamieStrauss's avatar
JamieStrauss
Qrew Member
2 years ago

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 ...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

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
------------------------------
JamieStrauss's avatar
JamieStrauss
Qrew Member
2 years ago

Thanks Mark! And my team thanks you too!  :)



------------------------------
Jamie Strauss
------------------------------