Retaining Formatting in 'joined' cells
 

In order to build a chart from my pivot tables that shows both a dollar
value, and a number of entries, I've downloaded XY Chart Labels so that I can
use an unrelated cell as the label source.

In that new cell, I have used the following command to generate my label:
="$"&ROUND(VALUE(D28),0) & "/" & VALUE(D27)

where D28 is the $ value, and D27 is the number of entries.

My problem is that the $ value doesn't include the comma in values exceeding
1000.

The source cells show the formatting as I want it to appear on the chart.
How can I get the chart label to look the same?

Retaining Formatting in 'joined' cells
 

Hi,

You need to format the result of the ROUND function.

="$"&TEXT(ROUND(VALUE(D28),0),"#,##0")& "/" & VALUE(D27)

Cheers
Andy

On 15/02/2010 16:15, Dowitch wrote:
="$"&ROUND(VALUE(D28),0)& "/"& VALUE(D27)

Retaining Formatting in 'joined' cells
 

Awesome. Worked brilliantly.

I knew it was probably something like that, but I'm really bad at using
formatting in formulae.

Thank you so much!

"Andy Pope" wrote:

Hi,

You need to format the result of the ROUND function.

="$"&TEXT(ROUND(VALUE(D28),0),"#,##0")& "/" & VALUE(D27)

Cheers
Andy

On 15/02/2010 16:15, Dowitch wrote:
="$"&ROUND(VALUE(D28),0)& "/"& VALUE(D27)
.