text to value

R

rick

a downloaded file from the main frame puts negative
numbers in the this format 123-

not -123

how can I change it once it is in a spreadsheet
 
G

Gord Dibben

Rick

A post from Peo Sjoblom.........................

With excel 2002 and later you can change that simply by selecting the column
with numbers, do data>text to columns,
click next twice and the click finish. The default setting will convert the
trailing minuses. Excel 97 and 2000
you can either use a help column and copy down this formula

=IF(RIGHT(A1)="-",---LEFT(A1,LEN(A1)-1),A1)

then copy the help column and paste it as values in place, the delete the
original column

Finally you could do as me and use J.E. McGimpsey's macro

http://www.mcgimpsey.com/excel/postfixnegatives.html

End Peo post....................

Gord Dibben Excel MVP
 
Top