Select Page

French Number format to Indian Number format

Convert data in the format 99.999.999,88 to 99,999,999.88 i.e French system to British System

Background

We in India (and most of the world) follow number format where we use comma [,] for separator and Full stop [.] for decimal separator.

Excel will recognise the following type of data as number and let you use to perform numerical calculations like SUM, AVERAGE, MAX and so on.
eg –   8,00,660.78
eg – 99,00,780.34
eg –         3489.8980

But if you export data from a ERP which is setup in one of the following country,

  • Canadian
  • Danish
  • Finnish
  • French
  • German
  • Italian
  • Norwegian
  • Spanish
  • Swedish
the number will be in following format

eg –   8.00.660,78
eg – 99.00.80,34
eg –         3489,8980
Excel will consider them as Text and will not let you use them for performing numerical calculations like SUM, AVERAGE, MAX and so on.

Use

The AdarshFrenchToIndian User Defined function will help you convert French number format to Indian number format.

This blog is owned by CA Adarsh Madrecha. All rights reserved.

About The Author

CA, ISA, CISA, BCAF. Friends call me Techno Savvy Chartered Accountant. I work at EY in System Audit

Leave a reply

Your email address will not be published. Required fields are marked *

Subscribe To my Newsletter

Subscribe To my Newsletter

Join the mailing list to receive the latest news and updates from the blog

You have Successfully Subscribed!

Pin It on Pinterest

Share This