formatting cells, excel, access, numbers and alphanumeric

[sniffinpoprocks]

How do I format a column of cells in excel so that I can view all the cells
in access?

columns that contain only text are fine, columns with only numbers are also
fine.

columns with both numeric and alpha.. cells dont display the cells with
numbers, I get #Num! instead.
I know if I put ' in front of the number I can see it but I have a large
database with numbers allready in the cells. any ideas? easy fixes without
going into each cell manually?

 

[Connie]

I would suggest you post your question in Office/Excel,
Miscellaneous. You're more apt to get an answer there.