Access setting Changes required to give effect to the regional settings RRS feed

  • Question

  • I changed the regional settings suitable to Indian method of spelling money in lakhs and crores.

    ex. 1 Crore displayed as 1,00,00,000.00 the effect takes place in excel work sheet. but in access 2007 it continue to display as 10,000,000.00 please advise the changes to be made to have the Indian system.

    Thank You.

    Tuesday, November 5, 2019 10:22 AM


  • This probably won't work in Access 2007, you'll need a newer version of Access.

    I have Access 2019, and it works OK for me:

    By the way, you have to set the grouping method in both the Numbers and the Currency tab:

    Regards, Hans Vogelaar (

    Tuesday, November 5, 2019 11:06 AM