What I hate about all these programs is that in their excel / calc programs, there's no provision for digit grouping in lakhs, crores etc. i.e. you can't write a number like 5,56,784 - it will come as 556,784 - really infuriating.... 
How is MS Office 2007?
- Thread starter boygr8
- Start date
- Replies 25
- Views 3,723
What I hate about all these programs is that in their excel / calc programs, there's no provision for digit grouping in lakhs, crores etc. i.e. you can't write a number like 5,56,784 - it will come as 556,784 - really infuriating....
You can format numbers anyway you want, if you use formatting.
type in a long number into a cell, hit return or just select the are you want formatted in this manner
right click the cell/area->Format Cells->Number->Custom
then enter the below code below where it says Type: in O2k3
[>=10000000]([$Rs.] ##\,##\,##\,##0.00);[>=100000]([$Rs.] ##\,##\,##0.00);([$Rs.] ##,##0.00)
should work upto 100 crores :thumbsup:
Youu get the idea so modify as appropriate.
You can format numbers anyway you want, if you use formatting.
type in a long number into a cell, hit return or just select the are you want formatted in this manner
right click the cell/area->Format Cells->Number->Custom
then enter the below code below where it says Type: in O2k3
[>=10000000]([$Rs.] ##\,##\,##\,##0.00);[>=100000]([$Rs.] ##\,##\,##0.00);([$Rs.] ##,##0.00)
should work upto 100 crores :thumbsup:
Youu get the idea so modify as appropriate.
As a makeshift solution that's what I do. but the problem is that if I enter 356000 in your code above it will come as ",03,56,000.00" Which means that I have to modify the formatting every time it jumps from thousands to lakhs to crores or vice-versa....... very irritating!!! Even though the "Regional and Language Settings" in XP let's you specify digit grouping as "Rs.12,34,56,789.00" it doesn't get implemented in MSOffice or Openoffice..... a pox on those $%@#$%.Edit: Wait I didn't see that there was a conditional way (>=10000000)... cool!! Does this only work in office 2003 or also other versions (and openoffice?)
