Forum Discussion
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 us...
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.
Thank you!