How do I make a # be a text field importing from Access into Xcel

[Patti_T]

I am using a Macro in Access to "Output to" Excel using an Object type of
"Report". there is a numeric field that needs to be a Text field in Excel
but Excel is automatically making it a numeric field. It is a Text field in
Access. Is there a way to ensure it stays a Text field in Excel?

 

[Steve Schapel]

Patti,

In the query that the report is based on, you could try forcing the data
to be a string via the Format function. For example...
FieldToUseInReport: Format([YourExistingField])

Don't know if it will help, but worth a try...