convert value in showing in lacs

[avishal007]

My balance sheet is prepared in rupees.
I want to show all figures in Lacs like value 235600 show 23.56

In previous year i divided all values one by one by inputting /100000 but its so tedious.
Pl help.

 

[VoG]

In a sparecell enter 100000 then copy it.

Select the values to convert, Edit > Paste Special, tick Divide and click OK.

 

[avishal007]

I tried it but my balance sheet show difference bcaz of rounding.

I also tried .00, for 235600 but its show 235.60 i want to show it 23.56 without separator.

Thanks