Excel probs....

[taken]

hi,

how can i get this type of output in excel cell. eg Rs. 12,34,567.00. have tried all the means. the steps that i have done is

control panel->regional options->in currency tab selected the digit grouping to 12,34,567 format.

then i have applied it. after that when i try to make the display to show me in this format then it just goes the old way of 123,456,789 way.

currency symbol is irrelevent. $ will also do.

where am i going wrong.

aken

 

[it_waaznt_me]

Hmm.. Check if the this option is set or not. If it isnt, then enable it :
Excel > Tools > Options
Click on International Tab
Enable Use system seperators
OK

Now try ..

 

[sakumar79]

Check out *www.mrexcel.com/archive2/29100/33176.htm

Arun

 

[taken]

hi, it_waaznt_me

the answer u gave didtn work out. as such it was already enabled. any help then?????

 

[taken]

can anyone link me to microsoft site for final and clear cut solution??? pleeeeeeeeeeease

 

[sakumar79]

[>9999999]"Rs."##,##,##,##0.00;[>99999]"Rs."##,##,##0.00;"Rs."##,##0.00

If you want to go beyond Rs.9999999, add before the above more cases. For eg,
[>999999999]"Rs."##,##,##,##,##0.00;
and then the rest.

Arun

 

[choudang]

can anyone link me to microsoft site for final and clear cut solution??? pleeeeeeeeeeease

*office.microsoft.com/en-us/default.aspx .... try it.


*www.danasoft.com/sig/greatwarrior.jpg

 

[mehulved]

I don't remember properly but AFAICR
1)right click on the cell(s) and click on format cells.
2)Select currency.
3) Select curreny type in Format drop down menu.
I can't check it on excel as I got linux but I checked it on Ooo.org but i suppose its the same in excel try it out and give your results here.