Exported Data Goes Awry

[Mitch Graham]

I have a database that Im generating reports from, and in these reports we
have columns to specify which "section" the items on the reports are in.
Example: Item 1 | Id num: 45 | Section num: 1.2.1

My problem occurs when i export the report to an excel spreadsheet. any
occurance of a section number x.x.x gets translated weird.
Example: a section number of 2.5.2 gets exported as 0.086828704 in the
Excel spreadsheet.

The section numbers are saved as text format in the database which is what
is baffling me. also, section numbers of x, x.x, or x.x.x.x are exported
just fine. its the x.x.x section numbers only that are showing up wrong.

also, i can export from access to a word file, or a rich text file, and the
numbers show up just fine.

 

[pietlinden]

I have a database that Im generating reports from, and in these reports we
have columns to specify which "section" the items on the reports are in.
Example:  Item 1  |  Id num: 45  |  Section num:  1.2.1

My problem occurs when i export the report to an excel spreadsheet.  any
occurance of a section number x.x.x gets translated weird.
Example:  a section number of 2.5.2 gets exported as 0.086828704 in the
Excel spreadsheet.

The section numbers are saved as text format in the database which is what
is baffling me.  also, section numbers of x, x.x, or x.x.x.x are exported
just fine.  its the x.x.x section numbers only that are showing up wrong.

also, i can export from access to a word file, or a rich text file, and the
numbers show up just fine.

What if you export to an Excel template that has that column formatted
as text?
Something like this:
http://www.mvps.org/access/modules/mdl0035.htm