Home |
Search |
Today's Posts |
#1
|
|||
|
|||
zero suppression on opening .xls file
If I create a tab delimited file as .xls , when I click on the file to open
it exel automatically suppresse the leading zeros on numeric fields. If i invoke excel first and then open the file it allows me to specify the numeric fields as 'text' and doesn't suppress the zero's. If i save the file and then doulble click on the file to open it ,everything is ok. What do I have to do so that excel will open the the tab delimited file the first time and not suppres the leading zero's? -- Don |
#2
|
|||
|
|||
zero suppression on opening .xls file
If you really save the file as a normal workbook with a .xls extension, then
excel knows how to treat each field--it's saved the formatting, the values, everything. If you save a text file with a .xls extension, then excel will only have the values. And there is no difference between 0000123 and 123. So excel just displays the value in a General format. If you want to keep the 0's, you can either File|open the text file and go through the data import wizard or you can apply a custom format after you import your data. don wrote: If I create a tab delimited file as .xls , when I click on the file to open it exel automatically suppresse the leading zeros on numeric fields. If i invoke excel first and then open the file it allows me to specify the numeric fields as 'text' and doesn't suppress the zero's. If i save the file and then doulble click on the file to open it ,everything is ok. What do I have to do so that excel will open the the tab delimited file the first time and not suppres the leading zero's? -- Don -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel getting Error - file format is not valid WHEN OPENING | Excel Discussion (Misc queries) | |||
Opening an Excel File | Excel Discussion (Misc queries) | |||
.CSV File into .XLS file | Excel Discussion (Misc queries) | |||
Excel opening but file does not open with Application | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |