Import Signed Numeric data

[ZSauce]

I need to import a text file into Access. One of the fields contained in the
text file is in Signed Numeric format, which I need to convert to a numeric
value in Access.

For example, 6705N in the text file should convert to -670.55 in Access.