PDA

View Full Version : Solved: figure in lacs



xls
07-25-2006, 12:39 AM
Most of the values in cells are running to billions & not able to read out report clearly. Is it possible to format cell in such a way that value shown in cell in lacs.
E.G.
Actual Cell Value = 123456789.00
Value after formating=1,234.57

Thanks in advance..

ALe
07-25-2006, 01:17 AM
create this custom format of the cell: #,00...

ALe
07-25-2006, 01:18 AM
I missed something... insert many 0 as many numbers you want after the comma

ALe
07-25-2006, 01:19 AM
use this if some values are less of 1 billion #0,000...

xls
07-25-2006, 01:38 AM
I think u did not understood the question. After applying above format result is "123,456,789..." rather tham as required by me.

ALe
07-25-2006, 01:44 AM
Mmmm look at the file example

xld
07-25-2006, 02:15 AM
I think u did not understood the question. After applying above format result is "123,456,789..." rather tham as required by me.

I don't think that you can do what you want. YOu could easily format as thousands, #,##0,.00, or millions, #,##0,,.00, but as you are dealing with lakhs, you want by ten thousand.

If you wanted standard Indian format but by thousands and millions you could use a custom format of [>=10000000]##\,##\,##0.00,;[>=100000]##\,##0.00,;##0.00,