Here!

Check this out -

http://support.microsoft.com/kb/213360

http://www.excelforum.com/excel-prog...an-format.html - Indian Format

You might have to tweak the code a bit as required

Deep