Forum Discussion

HarrisTse's avatar
HarrisTse
Qrew Member
2 years ago

Converting Number to Text

Hi guys, I have a question for converting number to text in QuickBase. For example, I have a numeric field show £29,190.90. But I want it to show as Twenty Nine Thousand, One Hundred and Ninety Pound...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

There is not a native function for that but there was a discussion a while back on the community and there's a very long and ugly formula that you could try to modify for your needs.  

https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=138d958b-698f-48c8-9211-3c6eac94dc6e&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

  • HarrisTse's avatar
    HarrisTse
    Qrew Member
    2 years ago

    Thank you for your suggestion!



    ------------------------------
    Harris Tse
    ------------------------------