Numbers and text

S

scubadiver

I have a link table from an Excel sheet. The first column is for account
numbers but some are numbers only and I get the "#num!" error. The only way I
can get rid of the error is to retype the number in Excel.

I have tried formatting the cells in Excel as "text" but it doesn't work.

Is there a work around?

Cheers
 
Top