Hello, I hope what I am looking for has a easy solution. So I have Drop downs that act as a filter and will display a cost in a text field. The text field currently shows as 1922.30103757865. I want to format that text field to show as rounded and in US dollars, so $1,922.30. The cost in data set reads as it is currently show in the text field.
Any help would be greatly appreciated! Thank you!
Hi!
Check forum posts on the same matter:
https://www.wix.com/corvid/forum/community-discussion/how-to-round-a-number
https://www.wix.com/corvid/forum/community-discussion/how-to-round-numbers
https://www.wix.com/corvid/forum/community-discussion/rounding-decimals-and-add-a-thousands-comma-separator
https://www.wix.com/corvid/forum/community-discussion/format-numbers-like-1-000-to-1k-and-1-000-000-to-1m
and you can always change your database fields to number :
https://support.wix.com/en/article/changing-a-database-collection-field-type