col of minus numbers changed to plus numbers
worked like a charm! thanks
"Ron Coderre" wrote:
Try this:
In an empty cell put -1
From the Excel main menu:
<edit<copy
Select the range of negative numbers
<edit<paste special
Check: Multiply
Check: Values
Click the [OK] button
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Cecil1234" wrote:
have long column of numbers showing as minus that was imported to worksheet.
need to convert them to plus.
|