Hi all,

I am trying to create a custom data label column to help tidy up a chart I've put together to report on email subject line open rates. Screenshot below:

oN2RuBr.jpg

Column Z is the total number of delivered emails, and column AA is showing the number using a K for thousands or M for millions, using this custom number format:

[>=1000000]#.#0,,"M";[>=1000]#,"K";0
How can I use this custom number format in column AC, where I want to combine values from other cells?

I want the data label column to say: 33.0% O/R, 39K delivered, Week 30

I am trying to use these functions together, but Excel is not happy about it! - 

=TEXT(X14,"0.0%")&" O/R, "&TEXT(AA14,[>=1000000]#.#0,,"M";[>=1000]#,"K";0)&" delivered, "&"Week "&AB14
Any ideas? Is it possible to use the text function with a custom number format?