Re: Change + to -

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: David McRitchie (dmcritchie_at_msn.com)
Date: 08/11/04 

Date: Wed, 11 Aug 2004 05:01:35 -0400

The following will work and should be a bit neater,
in the results, and it will retain formulas rather than
converting to values:
  Place -1 in an empty cell
  Select the area to be changed
  Edit, Paste Special, Multiply
Unfortunately it will convert blank cells to zero

To avoid that you can after choosing the selection area
  Ctrl+G (edit, go), Formulas
  Edit, Paste Special, Multiply
Doesn't matter what you choose for formulas it will
only process cells that look like numbers.

and then do the constants
  reselect the original selection area
  Ctrl+G (edit, go), Constants
  Edit, Paste Special, Multiply

Progression of multiple changes to a formula
  =1+1
  =(1+1)*-1
  =((1+1)*-1)*-1

Progression of multiple changes to a constant
  3
  -3
  3 

---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm
"Biff" <biffinpitt@comcast.net> wrote in message news:401b01c47f75$a9eb7c60$a601280a@phx.gbl...
> Hi Ulf!
>
> Here's one way if the value is the result of a formula:
>
> =IF(your formula=0,0,IF(your formula<0,your formula*-
> 1,your formula*-1))
>
> Or someone might be able to come up with a custom format.
>
> Biff
>
> >-----Original Message-----
> >Hi,
> >
> >If a result in a cell is for example 10,
> >I want the result to be -10.
> >If the result in a cell is -8,
> >I want the result to be 8.
> >
> >How is this done?
> >
> >/ Ulf
> >.
> >

Relevant Pages

  • Re: Windows & Dialog Stencil
    ... the Open at the bottom of the Edit menu is to ... stencil, you need to open the stencil and then right click the ... Then I can proceed to the "Show ShapeSheet" window and edit each ... User.Active is a boolean cell that is ...
    (microsoft.public.visio.general)
  • RE: Protected Formula Error
    ... or some other event code somewhere that is re-setting the protection. ... Edit directly in cell checked off. ...
    (microsoft.public.excel.programming)
  • Re: why can I still edit data when I set the "allowedits" property to
    ... If there is an edit in progress when you set the form's AllowEdits property ... you need a related table to hold the multiple ... The form properties have no apparent control. ...
    (microsoft.public.access.forms)
  • RE: Protected Formula Error
    ... Workbook and worksheet unprotected. ... All event macros commented out. ... Edit directly in cell checked off. ...
    (microsoft.public.excel.programming)
  • RE: Mulichoice Column Rendering in MOSS
    ... \par As for the multiple select column, I've performed some simple test as below: ... The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support ... These fields are placed in an edit panel and our authors ... \par would like to be able to display items in multiple columns to enhance ...
    (microsoft.public.sharepoint.portalserver.development)