Are you sure that the different Regional Settings for the PC's won't do what you want?

Simple example - I have my PC set to US Region and entered data.

Just changing the region to France, Excel very nicely reformatted the way the data was displayed

France.JPG
US.JPG

So maybe import the data with the PC set to the region that generated the data, and then change to your local region

Just a thought