| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
csv format drops a text character when reopened in Excel
Saved worksheet as .csv format which contains a cell with the text characters
"01" (zero one). When the .csv file is opened in Notepad, the "01" displays as it should, but when the .csv file is reopened in Excel the leading "0" is gone. The "01" is not "1" formatted as 0# or whatever, but is actual text. The .csv file is for export to another party, and requires a 2-position field. Any help is appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to assign character (text) values to y-axis in a Excel chart? | Charts and Charting in Excel | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| Format text across cells | New Users to Excel | |||
Threaded Mode
