Excel 2002 : Any fast way of converting positive to negative numbe

Posted to microsoft.public.excel.misc

Mr. Low

external usenet poster

Posts: 505

Excel 2002 : Any fast way of converting positive to negative numbe

Hi,

I have a block A1:AH6800 of positive numbers, may I know the fastest way of
converting it to negative numbers ?

At present, I use =- A1 at cell AJ1 and copy across and downwards.

Thanks

Low

--
A36B58K641

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
converting positive numbers to negative numbers	dmantzaaa	Excel Discussion (Misc queries)	1	January 29th 09 11:45 PM
Converting Negative Numbers to Positive	bmmclen	Excel Discussion (Misc queries)	9	February 8th 07 08:34 AM
Excel 2002 : Convert Positive Numbers to Negative Numbers ?	Mr. Low	Excel Discussion (Misc queries)	2	November 6th 06 03:30 PM
Converting positive numbers to negative numbers	Treg67	Excel Worksheet Functions	4	July 17th 06 03:57 PM
Converting negative/positive numbers to a CSV (Comma-delimited .TX	Frustrated Excel user	Excel Worksheet Functions	2	August 17th 05 05:51 PM

All times are GMT +1. The time now is 08:33 PM.

Menu

About Us