View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

When you import the file, you can specify that that field be treated as text.

Or after you import it as a numeric value, you can format that column with a
custom format of: 00



shedevel143 wrote:

I am exporting a tab delimited file into excel. The question is and not just
for this project but in general. I have a figure 05 and it always shows up
as 5. How can I get it to display the zero. Excel strips it , even in the
.xls. format.


--

Dave Peterson