Hi Team,
I am using the below formula for converting the number format to million formats however the same is not happening
=IF(ISTEXT(B4),B4, "")&TEXT(C4,"#,##0;;@")
the output is coming as 1,20,00,000 however I need the number as 12,000,000 could you please help
Thanks
I am using the below formula for converting the number format to million formats however the same is not happening
=IF(ISTEXT(B4),B4, "")&TEXT(C4,"#,##0;;@")
the output is coming as 1,20,00,000 however I need the number as 12,000,000 could you please help
Thanks