0

Format number as currency

Hi

 

How do I set a field as a curency field?   I still want to be able to show totals, etc. - so I guess I want this as an underyling number. I just want it shown with the correct currency symbol.

 

I'm on Ninox Desktop for MacOS

 

Thanks

 

Tom

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 11 mths ago
    • Reported - view

    Hi Tom -

     

    There is no specific currency field. You just use a Number or Formula field and then set the Number format.

    You can set it by editing the field and find the setting under Number format.

    Like
    • Mconneen
    • Mconneen
    • 11 mths ago
    • Reported - view

    @Tom,

    You have a few options.  You can create a number field .. then select the currency format as in the following image:

    1

     

    Or you can use the "format" function something like
    format('Accounting Numbers', "$#,##0.00")

    Like
Like Follow
  • 11 mths agoLast active
  • 2Replies
  • 315Views