Disable Automatic Negatives

Jul 19, 2006

Long Version: This should be a fairly simple question, with a solution involving unchecking a box somewhere, but I can't find it. Whenever I enter a number in parentheses (for example: "(187.13)") into a cell Excel automatically converts that number to a negative--- "(187.13)" becomes "-187.13". I've been using the apostrophe option as a workaround (i.e., '(187.13)) to store it as text instead of a number, but this is becoming a hassle because it recognizes that (187.13) is a number and alerts me with an error message of numbers being stored as text.

Short Version: Basically, I want it to stop automatically making "(187.13)" become "-187.13" but I don't know where the setting is.

View 7 Replies


Disable Automatic Axis Rescaling

Jan 16, 2007

to change the way my chart is presented. Each time I recalculate the series the chart is updated with the new numbers…however because these numbers can be substantially bigger from the numbers of the previous series the chart gets extended (x axis shrinks or extends) to compensate for the different length of the numbers on eh Y-scale…I wonder this rescaling of the x axis can be disabled…I attached the sheet with the chart…

View 3 Replies View Related

Automatic Calculation Upon Change-way To Disable For Certain Cells Only?

Dec 12, 2011

I have several data validation style drop down menus, and I basically don't want excel to recognize changes in these cells and execute a calculation of the entire workbook. Since there is a large number of calculations being performed in the workbook the sheet gets really slow.

Overall the way excel "automatically calculates" really screws me up a lot. This built in functionality could be a lot smarter in my opinion.

View 3 Replies View Related

Disable Automatic Absolute References When Linking To External Sheets?

May 30, 2014

Would be a massive time saver but can't find anything here or on Google on how to do this.

View 1 Replies View Related

Getting Negatives (-1) In Output

Jan 30, 2014

I am using one file, in that out put is coming but some times it is showing out put as -1.

Please find the attachment.

In the Sheet 1 Column X some out puts are coming as -1, what is the error in my formula.

Platform Open tickets on 29.01.2014.xlsx‎

View 1 Replies View Related

Replace All Negatives With 0 In Column

Apr 15, 2009

I have a column with both positive and negative numbers, is there a macro or a bit of code that will convert all negative numbers in a selected column to zeroes?

View 3 Replies View Related

Matching Negatives And Positives Once

Apr 30, 2009

I'm trying (with little success) to match some negatives and positives, but the formulas that I found on line keep on picking up all matches (just like a VLOOKUP formula)


The formula would match the -23 with the 2 positive 23s. This formula goes in Column O

View 4 Replies View Related

Percentage Formula With Negatives

Jan 28, 2009

I have a question regarding calculating percentage differences, here is how our formula works, but I've done a little research regarding using negative number for percentage calculations and am not sure...

For sample:

this year (TY) we had net profit of $200 million
last year (LY) we had net loss of -$32 million

our formula works kinda like this:


but if, the comparing numbers is negative should I convert that to an absolute number using ABS ? what if both numbers are negative ?

The way I understand the current formula is like this:

if B49 is blank, then insert a dash, otherwise IF B49 is 0, then 0 (since we can't divide by 0), otherwise do the formula.

View 9 Replies View Related

Add A Column Of Numbers, But Ignoring Negatives

Apr 7, 2009

I'm trying to SUM a column, but it has a negative number in it. I want to sum the column but ignore the negative number.


so the total would be 66. How is this possible or would i have to use another formula instead of SUM.

View 5 Replies View Related

Summing All Negatives Before Hitting A Positive

Aug 23, 2007

Let us say that this is a certain cash flow

Year - Cash flow
2007 - (200)
2008 - (100)
2009 - 50
2010 - 100
2011 - 200
2012 - (100)
2013 - (25)
2014 - 50
2015 - 300

For year 2007,2008,2012 and 2013, we have negative cash.

I want to compute for the investment cost, which I define to be the total accumulated cost before first positive cash. First positive cash occurs at 2009, so I want to sum 2007 and 2008, However, 2012 and 2013 also reports negative cash, so in the SUM formula, their values will be included.

How should I write the formula in order to sum all the negative cash before positive cash, disregarding all the other cash flows thereafter (be it positive or negative)?

View 9 Replies View Related

Allow Numbers Only In UserForm TextBox But No Negatives

Jan 25, 2010

I have the following code in a user form, attached to a data field that the user should fill. This code should alert the user if he enters a negative number i.s.o. a positive (and vise versa). Due language related issues, it is quite possible that the user will enter (by mistake) a negative sign but it will be at the end (500-) and the user will not notice this mistake. For some reason, my code does not pick up on this, and does not pop up the error message. Therefore, I decided that I need to check if the value entered by the user also contains a “-“ at the end of the string. This, I believe, will take care of the problem.

In excel, I would simply enter a formula with Mid and Len (to check if the last character is “-“) , but I don’t know how to implement it in my code.

Sub txt_sum_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
'Verify that a negative sign was added for expenses
With Me.txt_sum
Select Case cbo_act
Case "Expense",
If Me.txt_sum.Value > 0 Then
MsgBox "Number must be negative"
End If
Case "Income"
If Me.txt_sum.Value < 0 Then
MsgBox "Number must be positive"
End If
End Select
End With
End Sub

View 9 Replies View Related

Formula: Treat Negatives As Positives

Dec 8, 2006

i'm looking for a formula that gives the greatest number of a range
problem is that there are positive and negative numbers in the range
but I only want to look at the value (+/- signs are not important)

View 4 Replies View Related

Display Positive Numbers As Negatives

Feb 29, 2008

I would like to be able to enter numbers into a cell as a positive number, but have them actually display as negative in that cell.

View 2 Replies View Related

Formatting Keyboard Commands (negatives In Red With Parenthesis)

Dec 15, 2009

I use keyboard commands whenever possible. They are much quicker than the mouse.

For years I have been using [Ctrl]+[Shift]+[1] to format cells as numeric with two decimal places, 1000 separator(,) and showing negative numbers in black with a minus sign in front.

I like to see negatives in red with parenthesis.

View 5 Replies View Related

Sumproduct Formula And When To Use Comma's, Double Negatives, Addition

Jan 21, 2010

look at my attachment and see what I am doing wrong in my formula? I have a hard time understanding the Sumproduct formula and when to use comma's, double negatives, addition, etc.

View 2 Replies View Related

Custom Number Format For Negatives & Include Text

Aug 22, 2006

This is my formula and it returns: -55 bps.
=[ASK.xls]QTR!$AT$81&" "&"bps"

However, I want it to return (55 bps). I don't want to just add the parenthesis because in the future this formula could return a positive number. I tried to format the cell differently, but that did not work.

View 7 Replies View Related

How To Disable #N/A

Jul 23, 2007

I have this following codes on cell G6


i want it to show an empty cell instead of #N/A if it returns 0 value...

View 9 Replies View Related

Disable Save As PDF Or XPS

Apr 16, 2013

Is there a way to disable 'Save as PDF or XPS' with the macro? I have tried disabling 'Save as' with the below VBA code but it does not disable 'Save as PDF or XPS'.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI Then
MsgBox "Save As is disabled", vbInformation
Cancel = True
End If
End Sub

Also I have a macro which saves the excel report in a PDF format with 'Save as PDF or XPS' utility. I would like to enable 'Save as PDF or XPS' when this macro is started and again disable 'Save as PDF or XPS' when this macro stops.

View 1 Replies View Related

Disable A Button

Feb 1, 2010

I have a button on excel form. I need to disable it once user has clicked on it.

I couldnt find name of it on the form anywhere or how to refer it to in the macro.

View 9 Replies View Related

Disable Row Deletion

Mar 13, 2009

Excel 2003 - VBA - How do you detect when a row has been deleted in VBA? Better yet, how do you detect when a row is about to be deleted? I also would like to know the row number. I do not see an event handler that will inform me of the "Delete" event.

View 2 Replies View Related

Disable Macro Once Run

May 26, 2009

Is it possible to disable macro until next day once clicked to run

View 2 Replies View Related

Disable Cut And Drag Only Using VBA?

Jan 5, 2013

I need to disable cut and drag only in a workbook. The idea is to avoid formula reference errors when unlocked cells are cut and pasted or dragged. I can find many macros online but none that do only these two things.

View 2 Replies View Related

Always Disable Zero Values?

May 27, 2013

I am looking for a way that I can ensure that Zero Values are never shown, either when you open a new workbook or open a new window. Preferable, one which I can install for any user who needs this. (such as via Book.XLA I think) but AutoExec is fine as long as it is alwys loaded.

View 1 Replies View Related

How To Disable Read Only

Jul 10, 2013

I've got an excel sheet from a guy at work who decided to lock the entire document down so I can't do anything with it. Virtually all the ribbon options are greyed out, there isn't anything locking it in the code, I've tried checking the save as "read-only" option and it's not there. How I can actually save this is editable? I've looked in windows explorer and it's not read-only in there either. I tried save-as and even tried making it an XLS instead of an XLSM and it still won't let me edit it

View 1 Replies View Related

Disable ClearContents

Nov 30, 2006

I found this great code on this forum to disable copy/paste.

I would like to also disable ClearContents..

I can gather from the code that I just need to add a line similar to
EnableControl 755, False ' pastespecial

but change the # for the clearcontents command. But How can I find that number?

Sub DisableCopyCutAndPaste()
EnableControl 21, False ' cut
EnableControl 19, False ' copy
EnableControl 22, False ' paste
EnableControl 755, False ' pastespecial
Application.OnKey "^c", ""
Application.OnKey "^v", ""
Application.OnKey "+{DEL}", ""
Application.OnKey "+{INSERT}", ""
Application.CellDragAndDrop = False
Application.OnDoubleClick = "Dummy"
CommandBars("ToolBar List").Enabled = False
End Sub

View 9 Replies View Related

Disable Right Click. Can It Be Done?

May 1, 2007

Need code or way of disabling the Right Click feature in Excel? I think you can change it in the computer settings but I only want to disable it for a particular workbook so I am hoping there is a VBA Code that will tell the user "Right Click Not Allowed, Please use Cut and Paste or Ctrl +V and Ctrl +C"

View 9 Replies View Related

Disable Comments

Mar 3, 2008

I am sure this can be done - I found a similar thread but in a different context to what I need.

I have a user of a workbook who insists on putting irritating red cornered comments in cells, rather than using the handy (and rather large) comments field I put in, especially for her.

View 9 Replies View Related

How To Disable The X On A Form

Mar 18, 2008

i know in VB6 i could disable the X in the corner so someone can't X out of my form, and i see that's not an option in VBA.

So how can i stop the form from terminating when the user clicks that? i want them to be forced to use one of my buttons to close out and finish.

i tried adding something simple like Exit Sub to the Userform_Terminate() sub, but nothing. i can make code run when they click that, but i can't stop it from closing. what to do?

also, the form is being called by macro that does alot of other stuff before and after the form, so just opening a new instance of the form won't help unless you can stop my other code from continueing until the form is actually done...

View 9 Replies View Related

Way To Disable Help Feature

May 22, 2009

I just want to know if there is anyway to disable the help feature in Microsoft Excel?

I have to administer some exams.

View 9 Replies View Related

Disable Checkbox In VBA

Oct 6, 2009

I have a sheet with a number of checkboxes, and I need to conditionally enable/disable some of them.

For example, if the user checks Box1, then the question for Box2 becomes relevant and Box2 becomes available. If Box1 is unchecked, Box2 needs to be unchecked and disabled.

View 9 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved