formatting cells, excel, access, numbers and alphanumeric

  • Thread starter Thread starter sniffinpoprocks
  • Start date Start date
S

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 don't 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 already in the cells. any ideas? any easy fix without
going into each cell.
also, I need to know how I can edit the data later in excel and still see it
in access.
 
Sorry this is the MS Access (the database program) newsgroup. Try
an Excel newsgroup.

Hint. Highlight the cells, choose Format / Cells from the menu.
 
Create an extra Column in Excel (next to the mixed Column) and use the
worksheet TEXT() function to convert the mixed Column to purely Text. In
Access, used this Column instead of the original Column.

Check Excel Help on the TEXT() function.
 
Back
Top