OK. I came up with something that has seemed to initially work. If I add:
style="vnd.ms-excel.numberformat:Text" to the <td then i'm able to get it
to work. I can do this through my style sheet so every cell gets this
formatting.

thanks for any help that anyone may have put into this.

mark.

"nellie" wrote:

Sorry for the delay. I was working on something else and figured I would get
e-mailed any response. I think my filters might have sent it to a junk
folder. Oh well, enought about that.

I tried the program and it didn't seem to work for me. It put all the
contents into one cell. It is probably just the way my html and XML are
constructed. But here is a snip of what the html looks like(this HTML is
built using a XML file and Style Sheets):

<head<style TYPE="text/css"
table.TitleInfo
{
font-weight: bold;
text-align: left;
width: 100%;
}
table.schedule
{
border: 1px;
border-style: solid;
border-color: black;
border-collapse: collapse;
empty-cells: show;
}
td.value
{
text-align: left;
border: 1px;
border-style: solid;
border-color: black;
border-collapse: collapse;
}
</style</head
<body<table class="TitleInfo"<tr<tdMy Company,
Inc.</td</tr<tr<tdSchedule for</td</tr<tr<tdOur
Customer</td</tr</table<br /<table class="schedule"<tr<td
class="section"ISSUE NAME</td<td
class="value"SUPPLEMENTAL</td</tr<tr<td class="operation"JOB
NUMBER</td<td class="value"Job123</td</tr<tr<td
class="section"BATCH/FORM #</td<td class="value"05/12</td</tr

and then it continues on with different information. But my problem is the
"05/12" is not a date, but excel handles it as a date. I've tried the '
character, but excel doesn't hide it (although then it just displays at
'05/12 which is better then 05/12/2005). My other option is to just put ""
around the strings, but that is a last resort.

Maybe this will help out more.

Thanks

mark.


"Mark E. Philpot" wrote:

Hi,
I have just written a utility that "might" be able to do
whaat you want.

EasyText_Rev1.xls

http://www.geocities.com/excelmarksway

When you open the xls file, Click the picture to start the
form.

Click the open button, then select your file. The contents
of your file is loaded into a text box.

Another button can insert those contents into a cell in
the worksheet. Otherwise you can click the "Select All"
label, "Copy All Text", then hide EasyText, then select a
cell in the worksheet and ctr+v, or use your worksheet
paste. This will paste the contents to the worksheet, not
just the cell (depends if carriage returns are used in the
contents).


- Mark