Converting Number to Text

Question

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 Pounds and Ninety Pence Sterling. Can someone help me please? Thank you!!

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

markshnier__you · Answer

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.&nbsp;&nbsp;

https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=138d958b-698f-48c8-9211-3c6eac94dc6e&amp;CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&amp;tab=digestviewer
------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

harristse · Answer

Thank you for your suggestion!------------------------------Harris Tse------------------------------

Forum Discussion

Converting Number to Text