Exporting to Excel

[cross5900]

Do any of you guys know how when exporting a report to excel to make it include everything in the report, right now it is cutting out the zero's if they are first (e.g. 4-101-5690, when it should be 004-0101-05690)

I am thinking I have to make a excel template and somehow get it to export to that template. If this is the case if anyone could help me get that done, I would appreciate it.

 

[KeithG]

This is because the value is stored as a number in Excel instead of text.

 

[cross5900]

Yeah, how do I go about switching this so I can get the report to do what I want?

 

[cross5900]

I came up with a solution, I made the report go off the information that came out of a query. In the query instead of having 3 seperate areas for the account number (brnch, dlr, contract) I turned it into a string:

AccountNumber: [Branch] & "-" & [Dealer] & "-" & [Contract]

so that way it would output how I wanted on the report. Hope that helps anyone having the same problem