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

2 Replies

Related Content

converting text to number

Converting Date to Text

Pipeline to Concatenate Text and Increment Numbers

Convert timestamp to Date/Time

Convert a number to text

Recent Discussions

Time of Day field values are not in 24-hour format in Pipelines

Copied Field doesn't have the same usage as the original

Quickbase Actions

Tying Fields Together

When the Expiration Date is On or Before Today, Change the Contract Status to Expired