Import Negative #'s

[Guest]

When I import a text file into Excel, the negative numbers do not import as a
number (they are left aligned and cannot be summed). Is there a way to
convert these to number format? I have tried format/cell with no success.
If I retype the number, it it works but is too time consuming.

Thank you!

 

[Bob Phillips]

Try selecting the column, and Data>Text To Columns, fixed width with no
breaks.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)