| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Stop Excel from converting text labels in CSV files to Values
I have a rather frustrating problem. We have a macro that extracts plant
codes from a list and creates a csv file of these codes. Many of these codes have leading zeros, (ie. 0075, 0100, etc.) When this csv file is opened in Excel, it converts the labels to values (ie. 75, 100, etc.). I have opened the csv file in a text editor, and it shows the correct label - with leading zeros. Is there a way to get Excel to open this file without converting the text field to values? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Remove the apostrophe (') in Excel cell text values | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| How do I stop excel replacing numerical values with the date? | Excel Discussion (Misc queries) | |||
| Importing text files into Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
