Excel linked to access, data type problems

[gungfukid]

I have linked an Excel sheet to my Access database. Where I need numbers as well as text I have forced Access to make the field Text by using a dummy first row which I then delete.

The problem is that in text fields the numbers are not displayed, instead I get #num!

This is inconsistent however as on one field some numbers are displayed correctly and others have #num!

Why is this? How do I get all numbers to display in text fields?

Thanks!!

 

[Bastien]

use CStr(number) to convert the number to a string Bastien

There are many ways to skin this cat,
but it still tastes like chicken