Custom format [$Rs] #,##0.00 or #,##0.00 [$Rs] depend where symbol should be
(before/after value)
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
Microsoft Excel MVP
remove CAPS in email address
"Vinod" wrote in message
...
Is there any possibility to add new formats at "Number" tab in format
cells
dialog box apart from bult-in formats .
I wanted to add Indian currency (Rs) symbol in currency format list.
Advanced Thanks,
Vinod