Apr 25 2018
06:37 AM
- last edited on
Jul 12 2019
11:07 AM
by
TechCommunityAP
Apr 25 2018
06:37 AM
- last edited on
Jul 12 2019
11:07 AM
by
TechCommunityAP
It would be nice to make it possible to change default Column Data Format (currently General) in Excel Text Import Wizard by making entry in Registry. I know it is possible to do it for Encoding Settings when you go to
HKEY_CURRENT_USER>Software>Microsoft>Office>14.0>Excel>Options
and add new DWord item named DefaultCPG and then write decimal value inside for encoding. SO if you write 65001 Unicode (UTF-8), or if you write 852 you will have Central European encoding and when you Start Text Import Wizard in Step 1 offered Encoding by default is one you defined in Registry.
Does anyone know is it possible to do this in Registry?