Thread: col of minus numbers changed to plus numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
  
Posts: 2,118
Default col of minus numbers changed to plus numbers
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.
Reply With QuoteReply With Quote