| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Flipping numeric values
How do I flip a string of positive numbers to negative? I'm not
looking for a script, just some way to select the range of numbers and flip them. Dick Evans |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Flipping numeric values
Hi,
Am Sat, 13 Dec 2014 15:11:38 -0500 schrieb : How do I flip a string of positive numbers to negative? I'm not looking for a script, just some way to select the range of numbers and flip them. write -1 in a empty cell and copy this cell. Select your numbers and paste special = Multiply Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Flipping numeric values
On Sat, 13 Dec 2014 21:22:25 +0100, Claus Busch
wrote: Hi, Am Sat, 13 Dec 2014 15:11:38 -0500 schrieb : How do I flip a string of positive numbers to negative? I'm not looking for a script, just some way to select the range of numbers and flip them. write -1 in a empty cell and copy this cell. Select your numbers and paste special = Multiply I don't see a Multiply option. I'm using Excel 2010. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Flipping numeric values
Hi,
I don't see a Multiply option. I'm using Excel 2010. Paste = Paste Special = Multiply Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TO DELETE ONLY NUMERIC VALUES IN A CHARACTER AND NUMERIC CELL IN | Excel Discussion (Misc queries) | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Return Numeric Labels that have different Numeric Values | Excel Worksheet Functions | |||
| Non Numeric Values | Charts and Charting in Excel | |||
| Text values to numeric values | Excel Discussion (Misc queries) | |||
Linear Mode
