Skip to main content
Question

Converting Number to Text

  • February 16, 2024
  • 0 replies
  • 197 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

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
------------------------------