vmohan1978
Member
Dear All,
I want to format the -ve number like -1,557,896 to (INR 15.57M)
Please do the needful
I want to format the -ve number like -1,557,896 to (INR 15.57M)
Please do the needful
Formatting -ve number to Millions and with in the Brackets in Red Color
- Thread starter vmohan1978
- Start date
Somendra Misra
Excel Ninja
Hi Mohan,
Try #,##0.000;[Red]"(INR "-#.00,," M)";0.000
And your figure is 1.57 Million and not 15.57.
Regards,
Try #,##0.000;[Red]"(INR "-#.00,," M)";0.000
And your figure is 1.57 Million and not 15.57.
Regards,
vmohan1978
Member
Misra ,
Yeah it;s 1.57M , Thank you very much it worked perfectly
Yeah it;s 1.57M , Thank you very much it worked perfectly