Custom Formatting to display numbers in lakhs

[Vivek2705]

Hiii..

I want custom formatting for particular scenario..

125000 to 1.25
315600 to 3.16
512526 to 5.13

In short r/off in lakhs upto 2 decimals..is this possible from custom formatting? I don't want to use any of the round functions for the same..

[ben_hensel]

Yeah if you format as "Accouting" that will automatically display two decimal places. And you can select the appropriate currency symbol as well.

But do you also want it to divide it by 100,000 as well, or what?

[Vivek2705]

Yes I want it to divide by 100000 also..

[Aardigspook]

Try this custom format:
##,#\.##,

Please remember that formatting does not change the underlying number, so the 512526 will still calculate as 512526 - it will just display as 5.13 instead.