Minus Numbers with brackets treated as text

[ppete]

I'm pretty sure there must be an easy answer to this but I've searched the archives and can't find anything.

I'm setting up an import spec to help me import a text file. The trouble is that in the text file negative numbers have brackets ()around them and they are being thrown out because access thinks they're text.

Is there any way around this?

All the best,

Pete