LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Conditional Formatting (Compare Vals in 2 Columns) [email protected] Excel Worksheet Functions 3 April 21st 09 04:25 AM
remove automatic formatting of new columns in Excel? A Bit Gruntled Excel Discussion (Misc queries) 0 September 28th 05 02:25 AM
Formatting Columns in Excel defacto100 Excel Discussion (Misc queries) 1 May 16th 05 03:07 PM
Exporting to Excel, Then Formatting Columns/Cells Matt[_20_] Excel Programming 1 October 30th 03 12:36 AM
Formatting Cells/Columns in Excel 97 Wild Bill[_2_] Excel Programming 3 August 28th 03 12:33 PM


All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"