• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Changing the values from Indian Rupees to Dollars with correct spacing

Status
Not open for further replies.

VDS

Member
When we type the numeric values upto 5 digits, Indian Rupees and USD have the same number of sequence except the symbol. But when it is more than 5 digits, then USD should be displayed like $ 123,456 and Indian Rupees should be Rs 1,23,456. But In both the cases, it is displaying the same way. I tried to change through Custom format. But not able to do this. How this can be corrected. Sample data attached.


VDS
 

Attachments

KSKwin

New Member
Hi,

How to combine the below formulae {both positive & negative cases)

[<=-10000000]""- ##\,##\,##\,##0;[<=-100000]"" - ##\,##\,##0;" "##,##0

[>=10000000]" "##\,##\,##\,##0;[>=100000]" " ##\,##\,##0;" "##,##0
 
Status
Not open for further replies.
Top