Remember Me?

#1
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 1
change 2000 cells (negative numbers) into positive numbers

I have a colum of 2000 numbers (negative) and I would like to have them all
positive. I know I can multiple each number by -1 so it will be positive
(ex: -25 *-1=25) but I do not want to have to do *-1 to each cell, cell
by cell. Is there a way that I can change the sign in one shut?
#2
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 1,047
change 2000 cells (negative numbers) into positive numbers

hi Isbern

in an auxliar cell type -1, copy it, select the range when you need to
change the figures, right click, paste special
select values and multiply

hth
--
regards from Brazil
Marcelo

"lisbern" escreveu:

I have a colum of 2000 numbers (negative) and I would like to have them all
positive. I know I can multiple each number by -1 so it will be positive
(ex: -25 *-1=25) but I do not want to have to do *-1 to each cell, cell
by cell. Is there a way that I can change the sign in one shut?

#3
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 733
change 2000 cells (negative numbers) into positive numbers

lisbern wrote...
I have a colum of 2000 numbers (negative) and I would like to have them all
positive. I know I can multiple each number by -1 so it will be positive
(ex: -25 *-1=25) but I do not want to have to do *-1 to each cell, cell
by cell. Is there a way that I can change the sign in one shut?

Are they number constants? If so, Edit Replace, replacing - with
nothing.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Knold10 Excel Worksheet Functions 1 November 19th 05 04:02 AM Ellie Excel Worksheet Functions 5 September 5th 05 05:10 PM chom New Users to Excel 3 July 28th 05 08:26 AM Kara Excel Discussion (Misc queries) 0 February 7th 05 02:11 AM Dave Excel Discussion (Misc queries) 2 December 27th 04 02:28 PM

All times are GMT +1. The time now is 05:24 AM.