| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Commas in indian style
Hi!
sample number 123456789 In excel normally numbers are seprated in 1000's format ie 123,456,789.00 I NEED IT IN this format (indian style of rupees) 12,34,56,789 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Commas in indian style
Use a custom format of
[=10000000]##\,##\,##\,##0;[=100000]##\,##\,##0.00;##,##0 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "SVC" wrote in message ... Hi! sample number 123456789 In excel normally numbers are seprated in 1000's format ie 123,456,789.00 I NEED IT IN this format (indian style of rupees) 12,34,56,789 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Commas in indian style
How to add decimial points & can you explain this sequence of hash & zeros
"Bob Phillips" wrote in message ... Use a custom format of [=10000000]##\,##\,##\,##0;[=100000]##\,##\,##0.00;##,##0 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "SVC" wrote in message ... Hi! sample number 123456789 In excel normally numbers are seprated in 1000's format ie 123,456,789.00 I NEED IT IN this format (indian style of rupees) 12,34,56,789 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Commas in indian style
Decimal points
[=10000000]##\,##\,##\,##0.00;[=100000]##\,##\,##0.00;##,##0.00 All the hashes represent a number, but show as blank if they are leading zeroes. With normal numbers, you just define #,##0.00 and Excel will add a comma every 3rd digit, but as Indian numbers have commas in 2nd digit in some cases, it all has to be explicitly defined. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "SVC" wrote in message ... How to add decimial points & can you explain this sequence of hash & zeros "Bob Phillips" wrote in message ... Use a custom format of [=10000000]##\,##\,##\,##0;[=100000]##\,##\,##0.00;##,##0 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "SVC" wrote in message ... Hi! sample number 123456789 In excel normally numbers are seprated in 1000's format ie 123,456,789.00 I NEED IT IN this format (indian style of rupees) 12,34,56,789 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Commas in indian style
Dear Phillips,
my requirement is as below no matter what the number is it should display 2 decimal places & then going from left to right 1st 3 digits left alone after which there should be comma after every 2 digits. eg: 100 = 100.00 1000 = 1,000.00 10000 = 10,000.00 100000 = 1,00,000.00 1000000 = 10,00,000.00 10000000 = 1,00,00,000.00 100000000 = 10,00,00,000.00 1000000000 = 1,00,00,00,000.00 10000000000 = 10,00,00,00,000.00 ...... & so on "Bob Phillips" wrote in message ... Decimal points [=10000000]##\,##\,##\,##0.00;[=100000]##\,##\,##0.00;##,##0.00 All the hashes represent a number, but show as blank if they are leading zeroes. With normal numbers, you just define #,##0.00 and Excel will add a comma every 3rd digit, but as Indian numbers have commas in 2nd digit in some cases, it all has to be explicitly defined. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "SVC" wrote in message ... How to add decimial points & can you explain this sequence of hash & zeros "Bob Phillips" wrote in message ... Use a custom format of [=10000000]##\,##\,##\,##0;[=100000]##\,##\,##0.00;##,##0 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "SVC" wrote in message ... Hi! sample number 123456789 In excel normally numbers are seprated in 1000's format ie 123,456,789.00 I NEED IT IN this format (indian style of rupees) 12,34,56,789 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Commas in indian style
That is difficult, because the format only allows a certain number of
conditions, and we have exhausted them. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "SVC" wrote in message ... Dear Phillips, my requirement is as below no matter what the number is it should display 2 decimal places & then going from left to right 1st 3 digits left alone after which there should be comma after every 2 digits. eg: 100 = 100.00 1000 = 1,000.00 10000 = 10,000.00 100000 = 1,00,000.00 1000000 = 10,00,000.00 10000000 = 1,00,00,000.00 100000000 = 10,00,00,000.00 1000000000 = 1,00,00,00,000.00 10000000000 = 10,00,00,00,000.00 ..... & so on "Bob Phillips" wrote in message ... Decimal points [=10000000]##\,##\,##\,##0.00;[=100000]##\,##\,##0.00;##,##0.00 All the hashes represent a number, but show as blank if they are leading zeroes. With normal numbers, you just define #,##0.00 and Excel will add a comma every 3rd digit, but as Indian numbers have commas in 2nd digit in some cases, it all has to be explicitly defined. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "SVC" wrote in message ... How to add decimial points & can you explain this sequence of hash & zeros "Bob Phillips" wrote in message ... Use a custom format of [=10000000]##\,##\,##\,##0;[=100000]##\,##\,##0.00;##,##0 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "SVC" wrote in message ... Hi! sample number 123456789 In excel normally numbers are seprated in 1000's format ie 123,456,789.00 I NEED IT IN this format (indian style of rupees) 12,34,56,789 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can not delete Excel Style | Excel Discussion (Misc queries) | |||
| Currency, Percent and Comma Style buttons | Excel Worksheet Functions | |||
| changing font style in a complex worksheet function | Excel Worksheet Functions | |||
| thousand separator as indian style for negative number | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
