Hi, I accidentally found an answer to the question put up by N Shivkumar. So wanted to share the same, though I am sure most of you must have found the solution to this. Following are the steps:
1) Select the column/cell where you want to have the format with the new ` rupee symbol. 2) Change the format of the cell to Currency. 3) Go to Cell Format -> Choose Custom and paste the following: [>9999999]"` "##\,##\,##\,##0.00;[>99999]"` "##\,##\,##0.00;`##,##0.00 4) Change the font of the column/cell selected to Rupee Fordian. And thats all you need. You can now use the format painter to replicate this same format across wherever required. Cheers, Andy On Wed, Sep 8, 2010 at 12:14 PM, N.Shivkumar <shiv1...@gmail.com> wrote: > Thanx a lot I would like to know how to have the new symbol in the below > mentioned format : > > [>9999999]"Rs. "##\,##\,##\,##0.00;[>99999]"Rs. > "##\,##\,##0.00;Rs.##,##0.00 > N.SHIVKUMAR > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
