Hi,


I have done following tricks but not satisfied as :


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.

but when i am doing this trick in excel it is not working please tell me step 
by step to get new Rupee Symbol can mentioned in excel platform
 
Regards
 
sajid memon
                                          

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

Reply via email to