I would like to see digit (Number, Currency & Accounting) in BD Format. Like 12,20,30,570.50

[Mohammad Younous]

Hello Everyone

I would like to see digit (Number, Currency & Accounting) in BD Format. Like 12,20,30,570.50 . How is it possible?

Md. Younous
Dhaka
BD

 

[Somendra Misra]

Hi Mohammad Younous,

Format the cell with the value with custom format as #,##.00

Regards,

 

[Mohammad Younous]

Hi Somendra Misra,

Thanks for reply. But it dose not work.

 

[Somendra Misra]

@Mohammad Younous

Can you upload your file.

Regards,

 

[SirJB7]

Hi, Mohammad Younous!
Could you explain what is BD format? Keep in mind that this is an international forum.
Regards!

 

[NARAYANK991]

Hi Younous ,

See if these links help :

1. http://www.pcreview.co.uk/forums/excel-number-format-indian-style-lacs-crores-t942185.html

2. http://exertia.wordpress.com/2006/04/23/displaying-lakhs-and-crores-in-excel/

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

Narayan

 

[Mohammad Younous]

Thanks Narayank991. Your 1 No. link solve my problem.