"find and replace" negative numbers

hi!

select the range

goto
Data > Text to Col > Next > Next > Advanced >
check "Trailing minus for negative numbers" > ok


-via135

Originally Posted by pk

i have one columns of numbers which displays negative numbers in this format,
300-, this is after import from legacy conversion program. In Excel, how can
i convert this negative format from 999- to -999.


Tks !