ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Read both US and European Formats (https://www.excelbanter.com/excel-discussion-misc-queries/154479-read-both-us-european-formats.html)

MFINE

Read both US and European Formats
 
Hi, I am trying to get Excel to read both US numberical formats (","for
thousands, "." for decimal) and European formats (the opposite of US).

Is it possible to get Excel to read both at the same time, or to
automatically convert from one to the other?

Thanks

Marc


All times are GMT +1. The time now is 01:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com