LinkBack URL
About LinkBacks
ammartino44 
Hello. I have a spreadsheet that I'm trying to use to add a concatenated value for data labels. However when I concatenate the cells, the percentage cell returns a number instead of the percentage. Help!! Spreadsheet attached.
Alex
Hello. I have a spreadsheet that I'm trying to use to add a concatenated value for data labels. However when I concatenate the cells, the percentage cell returns a number instead of the percentage. Help!! Spreadsheet attached.
Alex
Hi amma,
Please find attached document for your reference.
Just replaced the formula from "=B3&" , "&C3" to "=B3&" , "&TEXT(C3,"0.00%")".
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
Also, how do I add that into the data label? I can select the cell that I concatenate but how can I concatenate the two values WITHIN the data lable?
That would not give you clarity. I have attached updated workbook see if it serve your purpose.Originally Posted by ammartino44
@ ADHAWAN06. Thanks for that. I actually have two columns I'm comparing (in my real data set) and the second is a % increase. It's weird that your formula works but in my spreadsheet it converts it to millions. I'll try again.
Cool, one more question: How do I add a comma for the number? It doesn't format it as a regular thousands with a comma. Not sure why.
Just replace your current formula from - "=B3&" , "&TEXT(C3,"0.00%")" to "=TEXT(B3,"#,##0")&" , "&TEXT(C3,"0.00%")"
This should do it:
Formula:
=TEXT(B3,"#,000")&", "&TEXT(C3,"#.00%")
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Both of those formulas change the number to millions. What's the difference between # and 0?
"0" refer to "Digit placeholder that displays insignificant digits (ie. digits that are zero)"
"#,##0" refer to Displays commas in between every three digits, for all values exceeding three digits
Hi Amma,
Thanks for sharing your feedback, If possible please share that original file (may be some content) else I wish you get your solution soon.
Is this what you are looking for?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks