Skip to main content

How to use the new Rupee Symbol in your documents

The new Rupee Symbol recently was released by the Reserve Bank of India and the Government of India. While the symbol may take upto two years to get included in the standard Unicode set of characters, many new fonts have already come up to help you use the symbol in documents.

Already most publications have started using the symbol. So I am sure you too would like to use it in your documents too. Here's how to do that.
Using the symbol in Excel shall require a different approach.
  • Install the font as explained above
  • On the cells you want to enter the "money" values, right click -> select "Format Cells"
  • On the "Number" tab select Custom
  • Enter [$`] #,##0.00 in the 'Type" box
  • For all such cells, specify the font to be used as "Rupee"
Done! You are good to go - if you type any alphabets in these cells, nothing will appear. Only numbers will appear in these cells. And the numbers shall have the Rupee Symbol automatically prefixed to them, just as the $ symbol is usually prefixed to cells which are formatted as "Currency".

Participation in the Rupee Symbol Contest
I and Shubham had also participated in the Rupee symbol contest. Our designs were very similar to the final winning entry - even our justifications for the symbols were quite similar to those presented finally.

The designs proposed by us along with the proposed rationale are below, we would love to know how you rate our designs, as against the design that finally won. Please leave your comments below:

Capital I in English Script, followed by the devangiri character "ra".

Rationale for the design:
1. Capital “I” represents India
2. "ra" in Devnagiri represents first character of rupaya or rupee. Devnagairi also represents Indian culture
3. The combined symbol created English R that stands for anglicised "R" in Rupee




Capital I in English Script, with a horizontal bar bisecting it.


Rationale for the design:
1. Capital “I” represents India and INR. It also represents the vertical Ashoka pillar.
2. The additional bar in middle creates 3 horizontal bars in total, representing 3 strips in our flag (and hence representing all that the Indian national flag stands for)
3. The simplicity of design represents the principles of “single living, high thinking” propagated by our founding fathers like Mahatma Gandhi.
4.This is a most simplistic design that can be drawn by anyone by hand easily

Parting Note: Even though none of our designs reached even the top 5, I am happy for two reasons - first that India finally does have a currency symbol of its own and second, the designs we proposed were quite similar and along similar lines as the final selected one. What do you think? Do leave your comments below.
.

Comments

  1. finally...found someone who could clearly specify the use in MS Word & Excel, etc.

    Thanks.

    ReplyDelete
  2. Thanks a ton Mr. Nikhil

    ReplyDelete

Post a Comment

Popular posts from this blog

How will travel industry transform post-Covid

Unlike philosophers, journalists and teenagers, the world of entrepreneurship does not permit the luxury of gazing into a crystal ball to predict the future. An entrepreneur’s world is instead made of MVPs (Minimum Viable Product), A/B Tests, launching products, features or services and gauging / measuring their reception in the market to arrive at verifiable truths which can drive the business forward. Which is why I have never written about my musings or hypothesis about travel industry – we usually either seek customer feedback or launch an MVPised version and gather market feedback. However, with Covid-19 travel bans across the globe, the industry is currently stuck – while a lot of industry reports and journalistic conjectures are out, there’s no definitive answer to the way forward. Besides there is no way to test your hypothesis since even the traveller does not know what they will do when skies open. So, I decided to don my blogger hat and take the luxury of crystal gazing

A Guide to Privacy on Social Media [apps]

The recent announcement by WhatsApp to update its privacy terms - and 'accept or leave the app' stance - led to an exodus of users from Whastapp to competing, privacy-conscious apps such as Telegram or Signal. A week after the exodus began, Whatsapp clarified its stance - and WhatsApp's CEO went about providing a long Twitter clarification . And then, many returned, many who considered moving stayed put on Whatsapp. This post is meant for those who are still sitting on the fence - it clarifies questions like: What is this all about? What do I do? Is Whatsapp safe? I've heard Telegram is Russian - so how is it safer than Whatsapp? I can't move because my business contacts are on Whastapp - how do I secure myself? PS: I've modeled this post based on several conversations I've had with friends and family on this subject, dealing with the chain of questions they ask, then objections they raise, then clarifications they seek - and finally the change resistance

Ekla Chalo re

Watched "Bose- The forgotten Hero" on Saturday. Gem of a movie and probably the best of Shyam Benegal. Subhash Chandra Bose has always been an inspiring character in the history for the youth. This post however is not about the movie, its about the lead song 'Tanha Rahee' which is based on the poem 'Ekla Chalo Re' by Gurudev Rabindranath Tagore. I had pasted the English translation of this poem on my blog earlier. http://the-complete-man.blogspot.com/2004/12/tsunami-times_30.html However, yesterday I found the original bengali text of the poem and found that the meaning in the above translation was not exact. So I have endeavourer (with the help of Shubham ) to re-translate it into English and Hindi by myself. Here is the output of my work: Bengali Jodi Tor Dak Soone Keu Na Asse Tobe Ekla Chalo re Ekla Chalo Ekla Chalo Ekla Chalore Jodi Keu Katha Na Kai Ore Ore O Abhaga Jodi Sabai Thake Mukh Firae Sabai Kare Bhay Tabe Paran Khule O Tui Mukh Fute Tor Maner Kath