If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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) |
#3
|
|||
|
|||
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) . |
Thread Tools | |
Display Modes | |
|
|