LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
don
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel getting Error - file format is not valid WHEN OPENING babu Excel Discussion (Misc queries) 1 August 24th 05 09:09 PM
Opening an Excel File jedi249 Excel Discussion (Misc queries) 5 April 16th 05 11:44 PM
.CSV File into .XLS file acyakos Excel Discussion (Misc queries) 5 April 7th 05 12:50 PM
Excel opening but file does not open with Application eWisdom Excel Discussion (Misc queries) 1 March 10th 05 05:53 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"