How to format currency and date



0
in this module, under the currency options, you have Rs..while i dont have it in my excel..how to add it?

2 Answer(s)


0

You have to use private character editor.

Click Start -> Run -> Type charmap.exe

Double click on the Indian Rs symbol and click copy

Open your excel file

Select the cells to format

Right Click on cells and Select Format Cells…

Click on custom category

Click on the Type Textbox and Press Ctrl + V to paste Indian Rupee Symbol

Click ok

0

You can also use RUPEEXL.vbs. Install it & it should appear.