Format number from UK format to Indian format

[tarunsuneja]

Hi,


My Bank Statement provides me the amount in UK format (100,000.00)

I want an easy formula to change it to Indian Format (1,00,000.00)


Many thanks,


Best Regards,

T. Suneja

 

[Luke M]

See here:

http://chandoo.org/wp/2010/07/26/indian-currency-format-excel/

 

[oldchippy]

Hi tarunsuneja,


Welcome to the forum! I wish my bank statement said £100,000.00

 

[SirJB7]

@oldchippy

Hi!

The biggest problem is that mine actually says: £(100,000.00)

Regards!

 

[Hui]

@SirJB7

RE: £(100,000.00)

That isn't your problem,

That is the banks problem

 

[SirJB7]

@Hui

You catch me... so the bank is trying to do...

Regards!

 

[hemasundar]

if you are using win xp or win 7 go to control panel and then to Region and Language settings there u can configure to indian number fomat