| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening .csv
Excel 97.
I have a VBA routine that opens a .csv file and processes some information. My problem is that excel changes some of the fields automatically upon opening it. For example, I have a field that reads "1002.10". Excel thinks that it is a number and automatically lops off the trailing zero. Is there anyway to turn off a setting so that excel will just open the .csv file as text and not try and convert any fields? Thanks, Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop blank workbook from opening when opening an existing | Excel Discussion (Misc queries) | |||
| Opening JPG | Excel Discussion (Misc queries) | |||
| REF errors when opening excel in xp. works fine when opening wor. | Excel Discussion (Misc queries) | |||
| How to make the opening of a workbook conditional upon the opening of another workbook | Excel Programming | |||
| How to make opening of workbook conditional of opening of another workbook | Excel Programming | |||
Threaded Mode
