Doors excel export format

I found out that when an object in Doors has value tex like "1/3/9" when this is exported to excel it looks like "2009-01-05" in excel, How I can avid this?

Thanks
esohgol - Wed Mar 16 09:19:58 EDT 2011

Re: Doors excel export format
llandale - Wed Mar 16 10:19:10 EDT 2011

I think you can select the column in excel and change its underlying type from "General" to "Text"; but then there's a limit on how many characters you can display.

On an individual case you can insert a space in the middle, perhaps "1/ 3/9" and Excel will no longer recognize it as a Date format, and then leave it alone.

Louie

Re: Doors excel export format
esohgol - Wed Mar 16 10:57:00 EDT 2011

I have done it Lois but it does not help.
/tanks

Re: Doors excel export format
SystemAdmin - Thu Mar 17 18:47:11 EDT 2011

esohgol - Wed Mar 16 10:57:00 EDT 2011
I have done it Lois but it does not help.
/tanks

MSExcel is too smart for itself - during an export, MSExcel will try to determine the data type of each column and apply that type accordingly.

The DOORS Export to MSExcel is very primitive and does not offer you the option to export to a specific MSExcel template where you can predefine the data type for each column and avoid this irritating issue.

I recommend that you get a copy of Michael Sutherland's classic "Enhanced Export to Excel" DXL script. This allows you to select many export options including exporting to a specific MSExcel template file - you can find it by clicking here - many other very useful DXL scripts here as well.

Paul Miller
Melbourne, Australia