Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Conditional Formatting (Compare Vals in 2 Columns) | Excel Worksheet Functions | |||
remove automatic formatting of new columns in Excel? | Excel Discussion (Misc queries) | |||
Formatting Columns in Excel | Excel Discussion (Misc queries) | |||
Exporting to Excel, Then Formatting Columns/Cells | Excel Programming | |||
Formatting Cells/Columns in Excel 97 | Excel Programming |