Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |