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 ...

Learning from 11 years in KPMG

It is only when we give up what we have is when we can embrace the new! I quit my job at KPMG one year ago - 22 January 2016 was my last day with the firm. As I reflect back on that day, it felt more like a graduation day! The eerie mix of nostalgia, excitement, anxiety and blues of missing your friends. KPMG was not just my first job but also a place where I learnt everything that I represent professionally. KPMG is one of the institutions I deeply respect and love – and relationships I have built here will stay with me for my lifetime. In my entrepreneurial career as well, I am often reminded more of all the great things I have learnt over my 11 years in KPMG. An year gone by, I realize these learnings have stayed with me and apply equally to the world outside KPMG. Almost all would apply to those working in role of (internal or external) consultants but several are generic and can be applied across professions. I have tried to change the text so that the learnings sound ...