Combining Text and Cell References Through A Formula

[RhyGuy]

Good Afternoon All,

I am running into a bit of a snag. I am trying to automate some of my reporting funtions by automating the text strings I would normally type out in our powerpoint decks that derive from information I have in my excel files. I am using the text that I know is standard and combining them with cell references throughout the worksheet.

Now I know how to combine text and cell references via fomula using the "Text" function, but where I am running into a wall is the formatting of the number itself. I want the number, if negative, to be in brackets, with one decimal point. With all numbers to have the 1000 Separator.

I have searched the net and have been coming up blank. Does anyone know how to properly format this?

Thanks In Advance

Ryan

 

[pgc01]

Hi Ryan

The syntax is the same as with cell formatting.

With the number in A1, write in B1:

="Example: "&TEXT(A1,"#,##0.00;(#,##0.0)")

In this case positive numbers have 2 decimals and negative numbers are enclosed in brackets with 1 decimal. Both positive and negative formats have the thousands separator.

 

[RhyGuy]

thanks man, really helps me out