How to modify placement of automatic commas in worksheet

[tanvir.bukhari]

I have received a workbook placing commas as xx,xx,xx,xxx in stead of the usual xxx,xxx,xxx. appreciate if someone could help me revert the workbook to the latter system. I have tried using the numbers section in the format section but unable rectify.

Thanks

[dogberry]

Hi Tanvir

Can you post a sample worksheet for us all to have a look at to see if we can help


Regards

Chris

[FDibbins]

based on your samples, try this...
=LEFT(SUBSTITUTE(A1,",",""),3)&","&MID(SUBSTITUTE(A1,",",""),3,3)&","&RIGHT(A1,3)

although i doubt your actual data is this simple?

[tanvir.bukhari]

Sample File uploaded. I believe the method should be simple - for the suggestions received from F dibbins & Dogberry, I doubt I know how to try or put them into effect?

Thanks in anticipation