Import csv-file Excel 2007

[Stein]

If I import a csv-file where numbers have . as decimal, I am not able to
import this correctly if I have , as decimal in Regional settings. I got both
.. as both for each 1000 and decimal; no numbers!
If I do the exact same in Excel 2003, it is working perfect.

As a workaround I change to , in my textfile before importing, but this is a
very unnecessary work.
Are there someone having solved this??

 

[Bernard Liengme]

In Excel 2003 I entered Jan, Feb, .... in A1:A10 and in B1:B10 I I entered
some decimal values 10.2,12.3,...
I saved the files as a CSV file and confirmed it opened correctly in Excel
2003 and Excel 2007
Then I change my Regional Setting to have comma as the decimal separator.
Now when I open the CSV file in EITHER version I get in A1 the entry:
Jan,10.1

So it would not seem to be an Excel 2007 problem at all. Why not recode a
macro to parse Jan,10.5 to Jan in one cell and 10,5 in the other?

best wishes

 

[Dave Peterson]

I'd do this (but I use xl2003):

I'd rename the .csv file to .txt.

Then use file|open to open the text file.

On the 3rd step of the text to columns wizard, there's an Advanced button (in
xl2003 at least). If I click that, I can specify the decimal and thousands
separator characters.

==========
You may want to try this:

In xl2003 menus, there's an option under:
tools|Options|International Tab
where you can tell excel how to handle numbers.

I bet that this option is under the Office button|excel options button
somewhere. (It'll take longer to find it than to test it <vbg>.)

 

[Bernard Liengme]

Dave< It takes arbour 10 seconds to find: Office | Excel Options | Advanced
tab | Edition Options (the first group)| last two items let you specify
thousands and decimal separators.
Happy New Year

 

[Dave Peterson]

Thanks Bernard.

Dave< It takes arbour 10 seconds to find: Office | Excel Options | Advanced
tab | Edition Options (the first group)| last two items let you specify
thousands and decimal separators.
Happy New Year
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email