Thread: How to keep Excel from formatting columns?
View Single Post
  #1   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,

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
Reply With QuoteReply With Quote