How to add a plus sign before positive numbers?

[Kate]

Adding a plus sign to positive numbers

Hi!

Is it somehow possible to automatically add a plus sign to the data in a table, which contains both positive and negative numbers, and retain the format (percentage)? 

Thanks

[Kate]

Hi!

Is it somehow possible to automatically add a plus sign to the data in a table, which contains both positive and negative numbers, and retain the format (percentage)? 

Thanks

[v-yulgu-msft]

Hi @Kate,

It is not possible to add a plus sign to positive numbers. If you add such a plus sign, the data type of field will be converted to Text rather than numeric.

Regards,

Yuliana Gu

[Anonymous]

Hi, 

any good ideas how to have this. I my case, with out the + sign, the figures look like % of of instead of % growth when shown with the + sign before

Sven

[Kate]

Thank you! I just wanted to make such  a column for my visualization, in which the type of data wouldn't matter.

[v-yulgu-msft · Accepted solution]

Hi @Kate,

You can create a calculated column via this formula:

Col2 = IF(Table1[Col1]>0, "+"&Table1[Col1],FORMAT(Table1[Col1], ""))

Regards,

Yuliana Gu