How to keep Excel from formatting columns?

[Axel Dahmen]

Hi,

Excel doesn't show one of my csv files correctly.

One of the columns contains numbers stored as, e.g., "195195,4989415". I've set this column to be displayed as "Text", still it rounds the numbers to 2 digits.

How can I tell Excel that this column is just plain text, not to be formatted?

TIA,
Axel Dahmen

 

[paul.robinson]

Hi
Look at Tools, Options, International. Is your decimal separator a
comma? Change it to a period if it is.
regards
Paul

 

[Jim Rech]

Excel handles the importing of CSV file automatically. Change the extension
to TXT and the Text Import Wizard opens up and you can designate the columns
you want to come in as text. I did that on a file with your example data
and it worked fine.

--
Jim
Hi,

Excel doesn't show one of my csv files correctly.

One of the columns contains numbers stored as, e.g., "195195,4989415". I've
set this column to be displayed as "Text", still it rounds the numbers to 2
digits.

How can I tell Excel that this column is just plain text, not to be
formatted?

TIA,
Axel Dahmen

 

[Axel Dahmen]

Hi Paul,

no, that wouldn't be a solution for me because in fact I'm German and this is the setting I usually work with.

You should be able to reproduce this problem using something like "1841351.891253". So the problem still exists. I'm searching for an international solution. I want my client to be able to edit a generated csv file that actually generates these decimal columns.

Can you reproduce this problem with numbers like the one above?

TIA,
Axel Dahmen


---------------------
Hi
Look at Tools, Options, International. Is your decimal separator a
comma? Change it to a period if it is.
regards
Paul

 

[Axel Dahmen]

Hi Jim,

could you have a look at the reply I gave to Paul? It applies to your answer as well.

TIA,
Axel