Leading Zeros

[JEB]

I am exporting a report from Access into Excel. One field has a store # - say 029. I need to have the leading zero in the field - but I can not get Excel to leave it there.

Any suggestions?

Thanks for the help.

Jeb

 

[mhartman]

You need to make sure that the column in Excel that this item goes in is formatted as "Text"

Regards
Mark

 

[JEB]

Thanks for the reply.

The problem is that I would like it to export directly from Acess into Excel- without opening an Excel worksheet and formatting the cells.

Is there a way to have Excel recognize numbers as text when being exported?

Thanks,
Jeb

 

[boblarson]

Just format your field in your query to export like this:
Num: Format(CStr([Number]),"000")
changing Num to whatever you want your column header to be
and [Number] to whatever your number field name is called.

 

[mhartman]

Hello:

I tried Bobs solution and could not get it to work when I ran the query and exported it.

YourNewColumn: "000" & [YourNumberField]

in a query does work though

Regards
Mark

 

[boblarson]

worked fine for me.

 

[JEB]

Didn't work for me. I am trying to export from an Acess REPORT - not just from the query. I don't know if that makes any difference

Thanks,
Jeb