I have a database that Im generating re****ts from, and in these re****ts we
have columns to specify which "section" the items on the re****ts are in.
Example: Item 1 | Id num: 45 | Section num: 1.2.1
My problem occurs when i ex****t the re****t 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 ex****ted 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 ex****ted
just fine. its the x.x.x section numbers only that are showing up wrong.
also, i can ex****t from access to a word file, or a rich text file, and
the
numbers show up just fine.
|
