Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2007

Tip: Looking for answers? Try searching our database.

How to change decimal separators when importing text (csv) files?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ron.Hatsten@gmail.com - 30 Sep 2007 10:00 GMT
I have a problem importing text files into Excel 2007.

I'm currently working on a German version of Excel 2007 running on a
German version of Windows XP Pro. Whenever I try to import data from a
text file (csv), every number with a decimal separator is recognized
as text.  This clearly is because of the decimal separators. The csv
files use points to separate decimals, whereas this German Windows is
used to separate decimals using commas.

Although the text import wizard allows me to select what type of
decimal and thousands separators are to be used, the separators are
always reset to the system default. To make this clear: I can select a
point as the decimal separator from the drop down list but Excel 2007
still uses the system standard (comma).

The "old" Excel 2003 had no such problem. Is there any way to overcome
this issue without changing the system standard for decimal separation?
Bernd P - 30 Sep 2007 13:14 GMT
Hello,

This link might help you:

http://www.erlandsendata.no/english/index.php?d=envbatextimportcsv

Regards,
Bernd

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.