Forum Discussion

mwneal77's avatar
mwneal77
Copper Contributor
Nov 10, 2017

CONCATENATE Formatting

I am trying to combine two strings of text using: CONCATENATE(TEXT(AB16, "#,#0")," - ",(TEXT(AC16, "#,#0"))). AB16 is equal to ($1,300) and AC16 is equal to ($1,700), even though the formatting is using the parentheses to display a negative value, when I combine the text it displays a "-" sign. Even when changing the formula to CONCATENATE(TEXT(AB16, "(#,#0)")," - ",(TEXT(AC16, "(#,#0)"))), it displays the text as -($1,300) - -($1,700). 

 

How can i change the formula display ($1,300) - ($1,700)?

Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Nov 10, 2017

    Hi,

     

    To convert the number to text use like

    TEXT(AB16,"#,#0;(#,#0)")

    first part of the string before semicolon formats positive numbers and second one is applied to negative ones.

     

     

Resources