Display number in brackets using toLocaleString for negative values

Question

I have been trying to change the numbers in AngularJS application according to the countries and used .toLocaleString function over entire application using below function

numberValueTransformation(value) {
    if (value === 0 || value === undefined) {
      return 0;
    }
    const currencyLocale = this.UserPreferences.getCountryLocale().replace(/fr-FR/g, 'de-DE');
    const currencyCode = this.UserPreferences.getCountryCode();
    return Number(value).toLocaleString(currencyLocale, {
      // style: 'currency',
      currency: currencyCode,
      minimumFractionDigits: 2
    });
}

The above function works perfectly fine but I have a requirement to show the negative values in brackets over whole application. Can we modify .toLocaleString to get the negative values in brackets or do I need to change in the entire application manually? I get the value as $123456689. But if a negative value i get -$123456789, but here i want the value as ($123456789) <--- brackets represents minus.

@RokoC.Buljan I think he means parentheses; i.e., "(100)" means -100. — Heretic Monkey, Feb 21 '19 at 18:55
There is no built-in method for these. See [How can I format numbers as dollars currency string in JavaScript?](https://stackoverflow.com/q/149055/215552) for some attempts. — Heretic Monkey, Feb 21 '19 at 18:59
Just out of curiosity, when and why would one want to put a negative number into a string, positive and inside brackets? — Roko C. Buljan, Feb 21 '19 at 19:00
@Roko C. Buljan. I needed to change currency values to their particular formats, such as if user wants euro format, then it should display the number like this 12.34.56,78 instead of USA format 12,34,56.78 and i think this way of doing in just the front end of the app is abolutely fine. — Aniruddhsingh Rathore, Feb 21 '19 at 19:08

Mathew Berg · Accepted Answer · 2021-01-16T13:48:47.863

4

Instead of directly returning the result, you can wire up the check yourself. Do the conversion on a positive number, if instead the original value is less then 0 then wrap in brackets.:

var absValue = Math.abs(value);
var returnString = Number(absValue).toLocaleString(currencyLocale, {
    // style: 'currency',
    currency: currencyCode,
    minimumFractionDigits: 2
});

return value < 0 ? '(' + returnString + ')' : returnString;

edited Jan 16 '21 at 13:48

answered Feb 21 '19 at 19:00

Mathew Berg

28,625
11
69
90

This worked very closer as i needed but i need a display where minus sign is outside the brackets. For eg ** -(123.233.42,99) ** – Aniruddhsingh Rathore Feb 21 '19 at 20:10
1

Updated my answer... just return the - in front. – Mathew Berg Feb 21 '19 at 20:26
1

For negative accounting numbers, the parentheses already signal a negative value. The minus sign is redundant. – cpopolo Jan 16 '21 at 03:32

score 3 · Answer 2 · answered Nov 18 '22 at 18:44

You can use .toLocaleString function directly as follows:

function numberValueTransformation(value) {

    if (value === null || value === undefined) {
      return 'some special value like N/A';
    }

    const currencyLocale = this.UserPreferences.getCountryLocale().replace(/fr-FR/g, 'de-DE');
    const currencyCode = this.UserPreferences.getCountryCode();

    return Number(value).toLocaleString(currencyLocale, {
      style: 'currency',
      currency: currencyCode,
      currencySign: 'accounting', // this is the key
      minimumFractionDigits: 2
    });
}

score 0 · Answer 3 · answered May 17 '21 at 16:09

For this maybe look at the numbro.js library https://numbrojs.com/ There is a feature to format negative values in brackets as requested. The code would work like this

console.log(
numbro(-123456.78).formatCurrency({
    thousandSeparated: true,
    mantissa: 2,
    negative: "parenthesis" // This does what you want
}))

<script src="https://cdn.jsdelivr.net/npm/numbro@2.3.1/dist/numbro.min.js"></script>

There are lots of other formatting options too see https://numbrojs.com/format.html#currency

Display number in brackets using toLocaleString for negative values

3 Answers3