| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting positive numbers to negative numbers
How can I convert positive numbers to negative numbers without retyping each
entry, thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Converting positive numbers to negative numbers
Enter -1 in an empty cell.
EditCopy. Select your positive numbers EditPaste special, check Multiply option HTH -- AP "Treg67" a écrit dans le message de news: ... How can I convert positive numbers to negative numbers without retyping each entry, thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Converting positive numbers to negative numbers
if the list is just postive numbers, type -1 in a cell and select and copy it, then select the positive numbers and past special, multipy. Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=562080 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Converting positive numbers to negative numbers
Treg67 wrote: How can I convert positive numbers to negative numbers without retyping each entry, thanks Hi, One way would be to type -1 (minus one) in a cell then - Edit - Copy. Select the range of values you want to convert and chose - Edit - Paste Special and here chose under under the Operations section - Multiply and click OK Regards, Bondi |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Converting positive numbers to negative numbers
Treg67, Type -1 in a cell. Copy that. Select the numbers you want to convert to negative. Paste Special and select Multiply. HTH, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=562080 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change positive numbers to negative numbers without re-ente | Excel Worksheet Functions | |||
| Displaying negative numbers - inconsistent between desktop and lap | Excel Discussion (Misc queries) | |||
| formula for negative and positive numbers in different columns | Excel Worksheet Functions | |||
| Compare Negative & Positive Numbers | New Users to Excel | |||
| add only positive numbers and avg in a column | Excel Worksheet Functions | |||
Hybrid Mode
