RE: Formatting an EXCEL Worksheet Generated From The 400

This doesn't solve the original problem if I read things
correctly.  If the value of a character field is 00255 Excel
will still interpret this as a number and lose the leading
zeros.  I checked this by using the html below and changing B
Widget's value to 00255.  Am I missing something?

Scott Mildenberger
--- Reggie Acosta <racosta@xxxxxxxxxxxxxxx> wrote:
> Recently, an associate, Ricky Thompson, gave me this tip. 
> He said, MS Excel will open a text file, formatted as an HTML 
> table, without any intervention if the file has a .xls
> extension. 
> Try it. Paste the HTML below into notepad and save it with the
> 
> .xls extension then open it in Excel.
> 
> You'll just need to create a the file with HTML table tags
> instead 
> of a CSV file. I'll leave that as an exercise for the reader.
> :)
> 
> <table border="1">
> <tr><td><b>Product
> Id</b></td><td><b>Description</b></td><td><b>On
> Hand</b></td><td></tr>
> <tr><td align="left">WIDGET-A</td><td align="left">A
> Widget</td><td>0</td></tr>
> <tr><td align="left">WIDGET-B</td><td align="left">B
> Widget</td><td>255</td></tr>
> </table>
> 



__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html