Numeric value of Rupees

Oaktree

MrExcel MVP

Joined

Jun 20, 2002

Messages

8,119

Office Version

1. 365

• Jul 7, 2008

• #2

Try:

""00","00","000"" for 01,23,456 or ""##","00","000"" for 1,23,456

 

Upvote 0

C

cslugdog

New Member

Joined

Jun 27, 2005

Messages

45

• Jul 7, 2008

• #3

I'll give it a try. Thanks!

 

Upvote 0

C

cslugdog

New Member

Joined

Jun 27, 2005

Messages

45

• Jul 31, 2008

• #4

I couldn't get this to work. Excel keeps putting the commas in the thousands position. Any other ideas?

 

Upvote 0

Oaktree

MrExcel MVP

Joined

Jun 20, 2002

Messages

8,119

Office Version

1. 365

• Jul 31, 2008

• #5

Please give an example of the incorrect result and what you'd like the correct result to look like instead.

 

Upvote 0

C

cslugdog

New Member

Joined

Jun 27, 2005

Messages

45

• Jul 31, 2008

• #6

In using the custom formatting you previously provided, no matter what I plug in, the number still shows up as 123,456 instead of 1,23,456.

 

Upvote 0

PA HS Teacher

Well-known Member

Joined

Jul 17, 2004

Messages

2,838

• Jul 31, 2008

• #7

cslugdog

Did you put double quotation marks where required.

e.g.

""##","00","000""

Not

"##","00","000"

 

Upvote 0

C

cslugdog

New Member

Joined

Jun 27, 2005

Messages

45

• Jul 31, 2008

• #8

Thank you so much! I was not entering the first (and last) quotations.

 

Upvote 0