geodude

I have a field in Access which is formatted is text. Here is a few
examples of the values in the field:

04033125105
04502552135

Even though there numbers I format them in text so I can keep the 0 in
front of the other numbers.

When I export to Excel I always lose the zero in front of the numbers.
I always end up having to use "concatenate" and format to text to fix
the problem. Does anyone know how I can export to Excel and keep my
formatting? I have Office 2003.

Thanks for the help.

douglas j steele

Put a single quote in front of the text to ensure it doesn't get changed by
Excel.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)