Wacky numbers when exporting to Excel

[poet1234]

Has anyone ever had this happen, and if so, what is the remedy? I have a report that the user needs exported to Excel. One of the report's fields is called WBS and is defined as text. The field contains the following types of values:
1.2
1.2.1
1.2.2
1.2.1.1
1.2.1.2
and so on. The problem is that when the data gets to Excel, any WBS that has 2 decimals (1.2.1, etc.) end up in a wacky state to the effect of 1.38230.28828 and all sorts of variations there of. This does not happen on any of the other WBSs.

Any thoughts?

 

[Liv Manto]

Try putting a letter in front of the first entry so Excel when it sees it has an Alphabet in it, would treat it as string. Just one data.

 

[poet1234]

I tried adding a letter and it didn't work -- the same problem occurred. Besides, why would this only happen in fields where there are 2 decimals in the value? I am completely at a loss...

 

[yellow]

There may be other ways but:

Change your control source to ="'" & [YourField]

This will export it as you want. Can you export the query instead of the report?