Excel appears to use new line rather than CR so:
<xsl:text>&-#-x-0-a-;</xsl:text>
without the dashes.
(ampersand octothorpe x zero a semi-colon)
-- 

Joe
"Leon Ford" <LeonFord@d...> wrote in message 
news:557448EB-D179-45F2-A57A-976E2C456932@m......
>I tried that already.  It produces the same results.  Thanks.
>
> "Joe Fawcett" wrote:
>
>> "Leon Ford" <LeonFord@d...> wrote in message
>> news:3DC180DF-D145-47B9-82D8-4634BFB8DACB@m......
>> > Ok, now that I know how to get the ampersand to show up in this post, I
>> > will
>> > try again.
>> >
>> > Excel produces this line when I format the item the way I want it and 
>> > save
>> > as XML, which is what I put into my XSL transformation file.
>> > <Cell ss:StyleID="sHeaders"><Data
>> > ss:Type="String">Contract
> Value
> ($M)</Data></Cell>
>> >
>> > How do I get the transformation to produce this line?
>> >
>> > "Leon Ford" wrote:
>> >
>> >> I am doing an XSL transformation of a dataset (using a 
>> >> XmlDataDocument)
>> >> to
>> >> create an Excel XML file.  Everything is working fine except that my
>> >> header
>> >> cells are not getting the line breaks like I want.
>> >>
>> >> When I explicitly format the headers in excel the way I want them and
>> >> save
>> >> the file as XML, the line built by excel is:
>> >>
>> >> <Cell ss:StyleID="sHeaders"><Data
>> >> ss:Type="String">Contract
>> >> Value
>> >> ($M)</Data></Cell>
>> >>
>> >> In my XSL transformation file, I have the following line:
>> >>
>> >> <Cell ss:StyleID="sHeaders"><Data
>> >> ss:Type="String">Contract
>> >> Value
>> >> ($M)</Data></Cell>
>> >>
>> >> When I do the transformation and save the XML file, the line produced 
>> >> is
>> >> (note the line wrap):
>> >>
>> >> <Cell ss:StyleID="sHeaders"><Data ss:Type="String">Contract
>> >> Value
>> >> ($M)</Data></Cell>
>> >>
>> >> When this is loaded into excel, the linebreaks are gone and the cell 
>> >> text
>> >> is
>> >> all on the same line.
>> >>
>> >> I have tried putting in the <xsl:preserve-space elements="*"/> into my
>> >> XSL
>> >> transformation file, as well as XmlDataDocument.PreserveWhitespace = 
>> >> True
>> >> prior to doing the transformation in my code.  This does not help.
>> >>
>> >> The bottom line, is that I need the final XML file to be exactly as 
>> >> show
>> >> below to have excel load this correctly.
>> >>
>> >> <Cell ss:StyleID="sHeaders"><Data
>> >> ss:Type="String">Contract
>> >> Value
>> >> ($M)</Data></Cell>
>> >>
>> >>
>> >> I am using Office 2003, Windows XP, and Visual Studio 2003.
>> >>
>> Maybe use:
>>
>> <xsl:text>
> </xsl:text>
>>
>> in between contract and value.
>>
>> -- 
>>
>> Joe Fawcett (MVP - XML)
>>
>> https://mvp.support.microsoft.com/profile=8AA9D5F5-E1C2-44C7-BCE8-8741D22D17A5
>>
>>
>>