Hi Pete,

Thnx for the reply.. The Custom number format does work for me.. But for number like 10,00,000.00 it adds a comma at the start.. Like ,10,00,000.00. How can I get rid of it?