Exporting to Excel - text appers as numeric

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use in a query: ClientNumEng: [Cltnum] & " - " & [CltEng]

Sample data:
000477 - 00000
000477 - 00001
000477 - 00002

In the report I use ClientNumEng as the control source and the report shows
everything fine. Once the report is generated, the user does an export to
Excel. When the Excel spreadsheet is generated, the number in the sample
data above appears as:
000477 - 00000
-519737
-519647

Why is this happening and what can I do about it??

Thanks!
 
start the calculated value with a single quote

ClientNumEng: "'" & [Cltnum] & " - " & [CltEng]

when it gets into Excel, this tells Excel it is text and to
line it up on the left

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
The ClientNumEng now looksmore like I wanted however they show up with that
singel quote. When I try to do a sort using that field, it dose not sort by
the ClientNumEng correctly. This is a BIG proble since the sorting is the
reason I'm exporting the report into Excel in the first place.

My other problem is that all the access reports show ClientNumEng the the
single quote. I could work aroung that by using Right([ClientNumEng],14).
The problem with this solution is that I use the query and the ClientNumEng
in many reoorts and I'd have to modify each one.

Are there any other solutions??

Thanks



strive4peace" <"strive4peace2006 at yaho said:
start the calculated value with a single quote

ClientNumEng: "'" & [Cltnum] & " - " & [CltEng]

when it gets into Excel, this tells Excel it is text and to
line it up on the left

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
I use in a query: ClientNumEng: [Cltnum] & " - " & [CltEng]

Sample data:
000477 - 00000
000477 - 00001
000477 - 00002

In the report I use ClientNumEng as the control source and the report shows
everything fine. Once the report is generated, the user does an export to
Excel. When the Excel spreadsheet is generated, the number in the sample
data above appears as:
000477 - 00000
-519737
-519647

Why is this happening and what can I do about it??

Thanks!
Click to expand...
Click to expand...
 
"The ClientNumEng now looksmore like I wanted however they
show up with that singel quote"

using the single quote should only be done on the query that
gets exported to Excel -- and it should not show.

What is the problem you are having with sorting in Access?
You can specify your sort by Cltnum, CltEng



Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
The ClientNumEng now looksmore like I wanted however they show up with that
singel quote. When I try to do a sort using that field, it dose not sort by
the ClientNumEng correctly. This is a BIG proble since the sorting is the
reason I'm exporting the report into Excel in the first place.

My other problem is that all the access reports show ClientNumEng the the
single quote. I could work aroung that by using Right([ClientNumEng],14).
The problem with this solution is that I use the query and the ClientNumEng
in many reoorts and I'd have to modify each one.

Are there any other solutions??

Thanks



:

start the calculated value with a single quote

ClientNumEng: "'" & [Cltnum] & " - " & [CltEng]

when it gets into Excel, this tells Excel it is text and to
line it up on the left

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
I use in a query: ClientNumEng: [Cltnum] & " - " & [CltEng]

Sample data:
000477 - 00000
000477 - 00001
000477 - 00002

In the report I use ClientNumEng as the control source and the report shows
everything fine. Once the report is generated, the user does an export to
Excel. When the Excel spreadsheet is generated, the number in the sample
data above appears as:
000477 - 00000
-519737
-519647

Why is this happening and what can I do about it??

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top