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

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

On Jun 19, 3:34*am, "Axel Dahmen" wrote:
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

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


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

On Jun 19, 3:34 am, "Axel Dahmen" wrote:
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

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
"Axel Dahmen" wrote in message
...
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

Hi Jim,

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

TIA,
Axel


-------------------
"Jim Rech" schrieb im Newsbeitrag ...
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
"Axel Dahmen" wrote in message
...
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