Excel International Decimal Separator.

Hello, we need to deal with different International Decimal Separators all the time, US and Abroad. The US uses the traditional period ("."), while the abroad files uses comma (",").

To change from one to another we go to Tools, Options, International and click or unclick the "Use the System Separator", while the decimal and thousands separators are already setup for the abroad system.

The problem is that Excel does not save this information within the xls file. So, opening any xls file, no matter its requirement for decimal separator, Excel will always use the last setup, no matter if this setup is the one for that file or not.

This cause a complete havok with our international and national documentation, since we always need to pay attention (and lots of it) if the separators are in accordance to the file being edited and printed. You can imagine how much printer paper we waste printing files with wrong separator setup.

Any way to save the setup with the file, or include a macro or auto-script with the file that automatically change this setup when the file is loaded?

Thanks for any help, we really appreciate it.

Wagner

See if this works for you. Put it into the Thisworkbook module

Please Login or Register  to view this content.

Change your decimal and thousands separator as necessary. Did that work?

If you go to the This Workbook module and change from "General" to "Workbook" the dropdown menu to the right will have the option of "Activate". Choose that and paste the guts of the previous subroutine into that one. You'll need to do that for all workbooks to change back and forth.

Right click on a worksheet tab (i.e. sheet1) and "View Code" This opens up the VBA editor. On the left there should be a docked window with "Sheet1, sheet2, sheet3, This workbook.... Double click on this workbook. A new textbox opens on the right with two dropdowns saying "General" and "Declarations" Procede from there.