Dear GURUS!

I would be grateful if you could help me in the following situation:

I had to link an Excel file to a MS Access Data Base and when I did it, I realised that there is a problem with one of the fields in the Excel file, which contains numbers, but is formated (and it is correct) as a Text field. There are some values, which are obviously not correct, because they appear as "#Num!" in Access. I know a way to correct this problem - to put manualy an apostrophe (') bewfore the problem value in the Excel file, but it is too slow and too unwise decision especially if you have too many values to correct. I tried to set the formula (Concatenate("'",A4) for example), but it has not the same effect :(... If I format the field as Text ,I also do not get what I need...

Could you, please tell me do you know some wise desicion of my problem - probably some kind of formating or somthing like that... ?

Thank you in advance!

With best wishes: