View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Axel Dahmen Axel Dahmen is offline
external usenet poster
 
Posts: 5
Default How to keep Excel from formatting columns?

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