LinkBack URL
About LinkBacks
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!
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.
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?
Just replace your current formula from - "=B3&" , "&TEXT(C3,"0.00%")" to "=TEXT(B3,"#,##0")&" , "&TEXT(C3,"0.00%")"Originally Posted by ammartino44
This should do it:
Formula:
Please Login or Register to view this content.
<---------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
That would not give you clarity. I have attached updated workbook see if it serve your purpose.
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
@ 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.
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