Tagged: currency format
- This topic has 7 replies, 4 voices, and was last updated 6 years, 2 months ago by
mila_support.
- AuthorPosts
- August 5, 2016 at 21:50 #10447
AnonymousInactiveWe’d like to display the currency amount with no decimal or preceding zeros:
Currency format: $1,000
Cell content: 1
Result: $1,000Currency format: $1,000
Cell content: 1000
Result: $1000,000The way it should display is:
Currency format: $1,000
Cell content: 1
Result: $1Currency format: $1,000
Cell content: 1000
Result: $1,000Is this possible?
August 9, 2016 at 16:20 #10460
AnonymousInactiveHello eric,
thank you for this issue-reporting. In one of the next versions we will make a function, which will be similar to this, which you want.
The field with number will have two delimiters: rank and fraction part. So the sum will be like this 1,000.00
But also we will add a check-box, where you could switch on?ff the fraction part. So if you switch it off you will see the result like this 1,000We hope this is ok for you
August 9, 2016 at 16:24 #10462
AnonymousInactiveHow soon can I expect this?
August 10, 2016 at 13:39 #10468
AnonymousInactiveHello eric,
We hope to make it till the end f next week.January 30, 2017 at 19:24 #12465
AnonymousInactiveDear support,
Is this function already available?
To be clear, I currently have a table with e.g. €1000,00 but I want €1000,- (or just €1000).
Thank you in advance for the help.
February 1, 2017 at 18:47 #12481
mila_supportMemberHi luca.spanjaard,
You can set the needed currency format at The Main Setting tab of your table
at Editor settings section – screenshot – http://prntscr.com/e336qyFebruary 26, 2017 at 14:50 #12757
AnonymousInactiveThank you for the explanation. It worked!
February 28, 2017 at 21:03 #12772
mila_supportMemberHello @luca.spanjaard
No problems, it’s always a big pleasure to help our users.
- AuthorPosts
- You must be logged in to reply to this topic.