RE: Formatting an EXCEL Worksheet Generated From The 400

["John Brandt Sr." <pgmr@xxxxxxxxxxxxxxx>]

Try this:
<table border="1">
  <tr>
      <td><b>Product Id</b></td>
      <td><b>Description</b></td>
      <td><b>On Hand</b></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 x:str="'00225">00255</td>
   </tr>
</table>

John Brandt
iStudio400.com


-----Original Message-----
From: Scott Mildenberger [mailto:scottmildenberger@xxxxxxxxx]
Sent: Tuesday, February 10, 2004 11:53 AM
To: Midrange Systems Technical Discussion
Subject: 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
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.576 / Virus Database: 365 - Release Date: 1/30/04
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.580 / Virus Database: 367 - Release Date: 2/6/04