LinkBack URL
About LinkBacks
Hi all, I have this code I'm using on the main sheet which links to another sheet, but I can't seem to get the numbers to add a comma if it's more than 1,000 etc. Any help would be great. Thanks.
Please Login or Register to view this content.
Hi all, I have this code I'm using on the main sheet which links to another sheet, but I can't seem to get the numbers to add a comma if it's more than 1,000 etc. Any help would be great. Thanks.
Please Login or Register to view this content.
Last edited by AliGW; 04-14-2020 at 11:05 AM. Reason: Irrelevant section of title removed.
You need to format the cells that the formula is in. Cell formatting is on the Home ribbon.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thank you, I did already try that without any luck, also tried a custom 'format cell' without any joy, but thank you for replying.
Try changing the formula to this:
=VALUE(INDEX(Lives!B2:B110,MATCH(MAX(Lives!C2:C110),Lives!C2:C110,FALSE),)&"Top live show"&MAX(Lives!C2:C110))
If this doesn't work with your number formatting, then attach a sample workbook - you must be doing something wrong. Instructions at the top of the page.
I've attached the simple sheet, I've added the corrected date format as well(thanks for the answer and support).
Seems to me that it is the same solution as the other thread -- use the TEXT() function to add number formatting to a number that you are joining into a larger text string.
=TEXT(date formula) & TEXT(number,"#,##0")
If you are unfamiliar with the number format codes that go into the second argument of the TEXT() function: https://support.microsoft.com/en-us/...rs=en-us&ad=us
Originally Posted by shg
Thanks, that was my first point of call, I just keep getting error messages. I'll get there lol
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks