As already mentioned before from Frank Schimmel:

USE CASE:
Use this signature for versioning: 1.1.1
Create an issue with "Fix for Version(s)" = 1.1.1.
Export a search result containing this issue and with active column "Fix for Version" to Excel.

EXPECTED:
In Excel, all columns retain the original format.

REAL:
The "Fix for Version(s)" column in the Excel document shows "01.01.2001", and reformatting (e.g. to Standard format") results in 36892.

NOTE:
A version like 1.0.0 does fine when exported to Excel.

NOTE additionally:

The suggested workaround :

Comment by Owen Fellows [08/Jul/04 01:23 PM] [ Permlink ]
This is because excel automatically converts it.

Can you try editing navigator-excel.jsp and changing
<%-- Fix For Versions (potentially costly call) --%>
<td>
<webwork:property value="./long('project')">
<webwork:if test="@fieldVisibility/fieldHidden(., 'fixVersions', ../string('type')) == false">
<webwork:property value="/issueManager/entitiesByIssue('IssueFixVersion', ..)" >
<%@ include file="/includes/snippets/listbyname.jsp" %>
</webwork:property>
</webwork:if>
</webwork:property>
</td>
to
<%-- Fix For Versions (potentially costly call) --%>
<td>"
<webwork:property value="./long('project')">
<webwork:if test="@fieldVisibility/fieldHidden(., 'fixVersions', ../string('type')) == false">
<webwork:property value="/issueManager/entitiesByIssue('IssueFixVersion', ..)" >
<%@ include file="/includes/snippets/listbyname.jsp" %>
</webwork:property>
</webwork:if>
</webwork:property>
"</td>

I'm not sure if this will work but work a try.

...

is unfortunately not helping.

Do you have any other idea?

Thx
Titus Leskien