Compounding Attribute issue

Hello All,

I am trying to suppress the compounding value in my workbook, seems like its a limitation. It always defaults to partial compounding. Is there any workaround to make it fully compounded.

Results :: C01/1222

Expected result : 1222

Any suggestions using macro ? or any work around you have taken please share. Appreciate your help in advance,.

Regards,

Siri.