We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

How to achieve MS Excel style of currency formatting (USA)

Answered
Support Desk asked on November 2, 2022

In MS Excel currency formatting (in US) is done by moving the symbol outside of the brackets and all the way to the left.
Negative number
$     (18.00)
Positive number
$     125.50
 
What is the right configuration to achieve this formatting?
 

5 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster November 3, 2022

Hello,

Thank you for reaching out to us.

At the moment, Flexmonster doesn’t support the described feature. However, our team will provide it with our minor release with an ETA December 12th. We will notify you about the release.

You are welcome to write to us in case further questions arise.

Kind regards,
Nadia

Public
Support Desk November 3, 2022

Great, we will check then.

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster December 13, 2022

Hello, 

We are pleased to inform you that the new formatting options $(1) and (1)$ were added to the negativeCurrencyFormat property.

The feature is available in the 2.9.40 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-40/ 

You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/ 

Please let us know if any questions arise.

Kind regards,
Nadia

Public
Maksym Diachenko Maksym Diachenko Flexmonster December 20, 2022

Hello,

Hope you are doing well.
Our team is wondering if you were able to test the new negative currency formats.
Please let us know if the feature works for you.

Kind Regards,
Maksym

Public
Maksym Diachenko Maksym Diachenko Flexmonster December 27, 2022

Hello,

We would like to know if you had time to test the new currency formatting features.
Looking forward to hearing your feedback.

Kind Regards,
Maksym

Please login or Register to Submit Answer