J
J.Sanchez
I have a text field containing values such
as "1.1.1", "1.2.2", etc. When I export to excel the
values are changed into numbers (0.42235, etc). I've
found an article related to a similar problem in Access
2000 and the proposed solution (export table/query) is
not very useful since I need the output to reproduce
exactly the report, so I get the right outlines in the
excel file (I'm queryign 3 tables and I need them
grouped). I'll appreciate any help on this subject.
Please reply by e-mail.
Interestingly enough, a similar field with only 2 digits
("1.1", "1.2", etc) in the same report is exported
without problems as text.
as "1.1.1", "1.2.2", etc. When I export to excel the
values are changed into numbers (0.42235, etc). I've
found an article related to a similar problem in Access
2000 and the proposed solution (export table/query) is
not very useful since I need the output to reproduce
exactly the report, so I get the right outlines in the
excel file (I'm queryign 3 tables and I need them
grouped). I'll appreciate any help on this subject.
Please reply by e-mail.
Interestingly enough, a similar field with only 2 digits
("1.1", "1.2", etc) in the same report is exported
without problems as text.