Shivam Garg
New Member
In ms excel how a numbers in a sheet can be displayed in (lakhs) or ( in crores).
number display options
- Thread starter Shivam Garg
- Start date
G Srinivasa Ramanujan
New Member
I tried using the above options, it does not work correctly when trying to change format to lakhs. further if it is converted to lakhs, the numbers which are negative will be displayed as -1234 and not (1234). can I get a quick advice on this.
NARAYANK991
Excel Ninja
Hi ,
Instead of merely saying that something does not work , upload your workbook which has the data that you wish to format , so that others can see what the problem is.
The first link posted by chirayu clearly shows the format to be used ; a format string has two parts for numeric values , one for positive values , and another for negative values.
Enter the complete format string , and everything should work correctly , both for positive values and for negative values.
Narayan
Instead of merely saying that something does not work , upload your workbook which has the data that you wish to format , so that others can see what the problem is.
The first link posted by chirayu clearly shows the format to be used ; a format string has two parts for numeric values , one for positive values , and another for negative values.
Enter the complete format string , and everything should work correctly , both for positive values and for negative values.
Narayan
G Srinivasa Ramanujan
New Member
Sir,
THanks for your response. I tried working out with both of them and could not get the desired result. attaching the file i tried working out. Kindly advice. I would be very grateful to you.
THanks for your response. I tried working out with both of them and could not get the desired result. attaching the file i tried working out. Kindly advice. I would be very grateful to you.