View Full Version : [SOLVED:] Figure in lacs
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..
create this custom format of the cell: #,00...
I missed something... insert many 0 as many numbers you want after the comma
use this if some values are less of 1 billion #0,000...
I think u did not understood the question. After applying above format result is "123,456,789..." rather tham as required by me.
Mmmm look at the file example
Bob Phillips
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,
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.