convert the figure of Rs. 143,250.00 into Rs 1.43 Lacs.

[Kumar Shanmugam]

I want to convert the figure of Rs. 143,250.00 into Rs 1.43 Lacs.

For example :-

Rs. 1,43,250.00 = Rs 1.43 Lacs
Rs. 28,55,785.00 = Rs 28.55 Lacs
Rs. 1,25,38,746.00 = Rs. 125.38 Lacs

Only through customer format under format cells. Please don't provide formula only provide custom format code

 

[Khalid NGO]

HI !

Only through customer format under format cells.

I don't think we have the simple solution for this using just cell formatting.

Here is a link, some users found this works for 1st time only:
http://chandoo.org/wp/2012/01/31/custom-number-formats-multiply-divide-by-any-power-of-10/

Regards,

 

[Kumar Shanmugam]

Hi thanks for your reply on priority.

but still I am in need of customer format code. Please assist anybody in forum.

 

[Nebu]

Hi:

Is this what you are looking for
Custom format:#\.00,

Thanks

 

[Kumar Shanmugam]

Thanks it worked..