Hello,

I have an excel workbook that outputs a file with numbers an
currencies. Since this Workbook is used globally and each region ha
its own regional setting, specifically digit grouping and decima
symbols interchanged. On creation the output file, th
numbers/currencies contain the decimal & digit grouping symbols a
their regional settings. But the file needs to contain decimals as do
and digit grouping as comma.

Before outputting the file, can we check the regional settings and i
its different from what is required, then change it and once the fil
is created revert it.

Please let me know if its a good option and if not suggest bette
ones.

Thanks

--
novice200
-----------------------------------------------------------------------
novice2005's Profile: http://www.excelforum.com/member.php...fo&userid=1640
View this thread: http://www.excelforum.com/showthread.php?threadid=27775