link excel erro: #Num1 2

[istone]

Hi,
I linked an excel sheet to my database but 2 fields have the following error:#Num!
In excel the records look like this;

Plan ID Plan Name1
169 Brickman
1231 Argo
AAM American
ART ArtMine

In the table in the database it looks like this:

Plan ID Plan Name1
#Num! Brickman
#Num! Argo
AAM American
ART ArtMine

Brickman and argo's ids are the only 2 that are numbers. I tried changing the format fo the cell to text but it did not help
Thanks in advance

 

[SkipVought]

Hi,

Prepend a TIC [red]'[/red] in each numeric cell

Skip,

_[red][/red]

 

[istone]

Sorry I don't understand what you mean by: Prepend a TIC...

thanks for your quick reply

 

[PHV]

a TIC
aka SINGLE QUOTE

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[istone]

Worked.
thank you so much.