Use currency format but don't display any symbol

[23Steve32]

Hi,

As the title suggests is it possible to use the currency format but not display a symbol? Basically I want to be able to use brackets on negative values for columns from the raw data.

Thanks in advance!

[mezesattila]

Hey All, I found a solution :-)))

A bit looks like a hack, but it works, hopefully. I am testing it now.

So... while formatting the Measure, select the Format drop-down text. Simply, just double-click on the text inside the drop-down menu. Type in the format as in Excel. The desired code for the number format is:

#,##0.00;(#,##0.00)

... and whoala!!! the magic happens.

Finally... I was looking for this solution for ages now.

Have a nice day!

Attila

[DeonDP2]

This is so cool - works a charm and I did not know you could just paste the format you want into the the tab.

Love it!!

[tmendoza]

Did you ever get a solid answer to this?

I'm going through the same thing and I don't want to use the FORMAT function because it turns my numbers into Text.

---

---

[mezesattila]

Hey All, I found a solution :-)))

A bit looks like a hack, but it works, hopefully. I am testing it now.

So... while formatting the Measure, select the Format drop-down text. Simply, just double-click on the text inside the drop-down menu. Type in the format as in Excel. The desired code for the number format is:

#,##0.00;(#,##0.00)

... and whoala!!! the magic happens.

Finally... I was looking for this solution for ages now.

Have a nice day!

Attila

[23Steve32]

So when using the number formats (whole or decimal) negatives are displated with a '-', when using currency negatives are displayed with ( ) so for example -100 would show as (£100).

What I would like to have is (100) rather than (£100) - in effect a currency but not showing the £ sign. Does this make sense? 

[spuder]

ok understand.

Try this one.

Column = FORMAT(table[origcolumn];"#,##0.00;(#,##0.00)")

[AlexBlair]

As @spuder says, you just need to set the data type to "Decimal Number" and have the decimal places set to 2?

Is this what you mean?

[spuder]

? a currency format without currency symbols is just a number (with fixed decimals)

Or did I totally misunderstand you