Import Negative #'s

  • Thread starter Thread starter Guest
  • Start date Start date
G

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