Data from Access is being changed when exported to Excel

[wabahn]

I have an Access report that when it is exported to Excel, some of the data is being changed. The problem is a text field with a part number. All of the part numbers are formatted with 9999999-9. The part numbers starting as 2034XXX-X are changing to a 6 digit number (as an example 2034080-1 exports as 205999, 2034081-1 becomes 206365, 2034082-1 becomes 206730)

If the part number starts with any other set of numbers, the excel file exports the same value in the 9999999-9 format.

Does anyone have a clue as to what may be happening during the export and how to prevent it?

 

[Blorf]

I think the 2034 part is coincidence.

It looks like excel / access it trying to convert your value to a date because of the dash, and on the 9 numbers, it's too large, so it leaves it as text.

You need your report to have the value start with a non numeric value, I use ' and when I open my excel file, I do a find and replace for ' to nothing.

Neat problem though.

ChaZ



There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://www.thelegacyreturns.com/

 

[SeeThru]

Yes- had this before - it think they are numbers and performs a calculation.

Either

Don't use Excel!
Add a prefix '
Add a non-numerical character or space somewhere in the value

SeeThru
Synergy Connections Ltd - Uk Telemarketing and Telesales Services and
Synergy Mobile Solutions - UK Mobile phones, land lines and call packages