Indian Number Formatting of Currency in Microsoft Access and Excel

Gustav Brock

Rate me:

5.00/5 (1 vote)

1 Feb 2021MIT7 min read

4.4K

Format amounts in VBA using the Indian number format for currency and amounts

The Indian number format for currency has groups of two digits where Western format has groups of three digits. The native Format function of VBA cannot handle this if Windows is set for a Western localisation. Thus, a custom method must be applied. Here, it will be shown how to use dynamic formatting to accomplish this.

Views

Daily Counts

Downloads

Weekly Counts

License

This article, along with any associated source code and files, is licensed under The MIT License

Written By

Gustav Brock

Architect Cactus Data ApS

Denmark

Microsoft MVP, Most Valuable Professional, since 2017.

It started with BASIC in the 80s, then moved to PDC Prolog, and then - when Access 1.0 was launched - "back to Basic", or rather Access Basic. Then followed VBA (Visual Basic for Applications) starting with Microsoft Access 95/97 and still going with Access 2019/365.

Still I do some VBA, but since 2008 my main focus has been C#.

Application area is mainly accounting and custom applications related to accounting.

Indian Number Formatting of Currency in Microsoft Access and Excel

Views

Downloads

License

Comments and Discussions