Import Negative #'s

E

Eric

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!
 
B

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)
 
Top