How to set the default Excel cell format when opening XML to XLS using an existing stylesheet?

[IdoZe]

Hi,

I have an XML file, which I'm opening with the Excel application. The stylesheet I use is horizontal.xsl.

The problem arised when the XML has data in the format "1/4" or "1/16", which is translated in the Excel as date (like "01/04/2007").

I think I have to set the default cell type to "Text" instead of "General". Does anyone know how it can be done?

[~jiggawax~]

If you select all the cells in Excel and right click on them and say Format Cells there should be a Number tab.  On it you should have the option to select Text.

[anita_tck]

how to set it???

[RayFarmer]

Is this the same question as idoZo, if so jigg has already answered it. If not then you should post your own query not hijack someone elses giving a clear and concise question, "how to set it??" doesn't help you or other in the forum to provide you with a solution.

Is this relevant to TestStand? If it is then help by providing which version you are using and what software you are using with it. If not then post your question in the correct board.

[Akiel]

I have a similar problem, I am openning an xml report in excel using the horozontal stylesheet (teststand 3,5 and excel 2003) is there a way to open the xml file using the stylesheet without the operator needing to specify whether to use horozontal or open it without a stylesheet. This is proberly more an excel problem than teststand but I believe others may have had this problem

Thanks in advance

[Jensen W]

I have not seen a way to do this yet.  I will keep looking, but in the future I think this issue is different enough that it should go on it's own thread.

[Akiel]

ok thanks, will repost as a new thread, thanks for feedback