Exporting to Excel format question

G

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.
 
D

Douglas J Steele

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