Adding a comma to numbers

[RBLearning]

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.

=INDEX(Lives!B2:B110,MATCH(MAX(Lives!C2:C110),Lives!C2:C110,FALSE),)&"Top live show"&MAX(Lives!C2:C110)

[AliGW]

You need to format the cells that the formula is in. Cell formatting is on the Home ribbon.

[RBLearning]

Thank you, I did already try that without any luck, also tried a custom 'format cell' without any joy, but thank you for replying.

[AliGW]

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.

[RBLearning]

I've attached the simple sheet, I've added the corrected date format as well(thanks for the answer and support).

[MrShorty]

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

[RBLearning]

Thanks, that was my first point of call, I just keep getting error messages. I'll get there lol