Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to custom format a cell to read 00,00,000, instead of the usual comma
after three spaces. This is for an application that uses Rupees, which have a comma break at 1,000, then the next 100, and then another 100. In other words, whereas 10M would normally print "10,000,000", I need it to print "100,00,000". Further, I need every 1,000 after this to be at the three digit mark. In other words, 1B would need to print as "100,000,00,00,000". The key here is to get a comma between the uptick from 99,000 to 100,000, so that it shows up 1,00,000; and the next comma to show between the uptick from 9,999,000 to 10,000,000, where the 10M should show up as 1,00,00,000. I'd also ideally like to have "Rs." printed right before the number. If anyone can give me the custom field text for formatting, would be greatly appreciated. Thx. -- Boris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting for Indian Rupees | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |