Search results

Narayan mmm Yeah, so what you said in your first reply has worked the second time. Possibly I cut and pasted something incorrectly, though I have been getting to grips with formatting cells (they now both match as per post no.4: set to number, decimal places 0, with the use 1000 separator...

Narayan, I'll post the results of the two previous attempts so you can see the outcome.

Thought I'd mention how important the commas are they need to be kept in the cells and without spaces, exactly like IN my initial post. I think from what I can see, both columns are set to number, decimal places 0 with the use 1000 separator ticked. They columns are id's are actually X2...

Thanks for your help, tried both ways suggested above and neither worked. I'm not sure how to identify whether the cells are formatted as numbers or text. I'll have a look through the forum and try find a way to identify them. I was going to upload a sheet as an example but can't see any...

Hello A1: 614,735 B1: 899 I would like C1 to show: 614,735,899 I'm new to excel and this forum, please can anyone advise me of what formula or combination of formula and settings would get this to work. I'm using Excel 2013. Thnak You