# Minus Sign - Turn Into Negative Number Without Manually Keying Each One?

Feb 14, 2013

I have a column of numbers which have the - sign at the back end of the number instead of the front. What would be the easiest way to turn that into a negative number without manually keying each one?

## Convert Negative Numbers With Negative Sign On Right

Aug 1, 2007

I have data that comes from a subsytem that places the negative sign at the right of the number, so it is recognized as text. I can get around this using find and replace and then a second step to multiply that by -1, but is there a formula that can do this for me?

I was trying if(right(A1,1)="-",TBD,A1)

## Plus Or Minus Sign In The Beginning?

Jul 29, 2008

I want to save phone no as +99 9876543210 in excel 2003 on my xp pro machine. But if i give a + sign in the cell, some blue dotted rectangle shows up and everything messes up.. I think it is treating it as a formula or something... how can i save this in the cell. tell me in detail if you are going to tell me about macros or vb code as I don't know how to insert code or program macros.

## How To Show Minus Value In A Formula As Plus Sign

May 31, 2014

I have attached here an excel sheet with some data. I need to show the minus value in D5 as a plus sign, is there any conditional formula to work this out??

## Reversing Sign Based On Cell Being Manually Coloured

Nov 13, 2008

I have a range: AC2:AG1400 that are filled with numbers....

Someone manually highlighted, in bright yellow, some of the numbers.

I need a macro that could reverse the signs of only those that are coloured in that yellow.

## Inserting Minus Sign In Front Of Numbers In A Range

Mar 19, 2009

i want to know how to prefix a minus sign (-) before numbers in cells in a large range.i m working on a large sheet containing the Numbers with Cr and Dr as suffixes just like 445Dr ... 3331Cr and so..on... in the worksheet

i want to know the method of deleting the suffixes and prefixing - sign infront of numbers having Cr as the suffix.

Numbers with Dr as suffix denote positive numbers
and numbers with Cr suffix denote negative numbers. i want to prefix the -minus sign in front of numbers having Cr in the end.

## Turn Off Automatic And Manual Calculation Modes Manually?

Dec 12, 2011

I know how to turn off automatic and manual calculation modes manually in excel or through VB. But is there a way to make the automatic calculation mode ignore changes in certian cells? It would be good if you could right click on a cell and turn this on/off as an option. I assume I will have to code this in vb somehow, but I am a novice. Something like:

Sub test123()
For Cells = Value.Range("I7:R22")
Application.Calculation = xlCalculationManual

Like I basically want part of my sheet to be set to manual calculation mode, and partially to automatic...

## Red Negative With £ Sign

Oct 24, 2008

is it possible to display the value in a cell with a £ and also make it automatically go red when the sum is negative?

## Sum Positive And Negative Numbers Regardless Of Sign

Jul 14, 2006

I have a colum of positive and negative numbers I want to sum all the numbers regardless of the sign. Example
-1500
8000
-2500
4000
=16000

I can not work in another colum or covert the negative numbers in another colum then add them up.

I need last cell to read 16000. What formula do I need?

## Format To Change Negative/positive Sign

Aug 25, 2009

I have a cell that always requires a negative currency number.

No doubt I will inadvertently enter a positive number now and then.

Is there a conditional format method or something that will take my cell entry and always change it to negative?

## Formula To Sum All Numbers With Same Sign (negative / Positive)

Jul 23, 2012

I am looking for a formula to do the following:

In Tab 1, I have a negative number and the word "Original" next to it. In Tab 2, I have a mix of positive & negative numbers. I want all numbers that are negative to display the word "original" and all positive to display" new." How do I do that? Also, I want the opposite to work as well-- if Tab 1 has a positive number, I want all positive numbers in Tab 2 to display "original."

## Formula To Show Time In Hours Going Minus Instead Of Negative

Nov 4, 2012

I have devised a simple formula when a member of staff enters a date and time into a cell it starts deducting from todays date and time. ie:

Cell A1 - Date and time is entered by staff

Cell B1 - Is the above cell +24hrs

Cell C1 - NOW()

Cell D1 - B1-C1 Formatted in hours ( [h] :mm:ss (Like a count down clock)

The problem i have is that i cannot get Cell D1 to show minus ours it just goes to negative and shows continous #####. Is there any way i can get Cell D1 to show the hours it has gone minus by.

## Prefix Negative Sign To A Positive Numeric Character

Aug 21, 2009

The report generated from our co. software in excel have negative figures suffixed as "-" for ex., payable shown as 21373533-

- The value is treated as text in excel

- How should i Bring the negative sign for this type of data as prefix
when there is huge data and also in a columnar manner.

## Conditional Properties: If A Number In A Different Cell Is Above A Certain Number It Will Turn Green And Another Cell To Turn Red

Dec 10, 2008

can I set a cell in excel so that if a number in a different cell is above a certain number it will turn green and another cell to turn red. I have attached the file.

## Fill Up Column Without Over Keying All Data

Mar 26, 2013

I have a spreadsheet that I need to fill up the columns of blank cells stopping when it reaches data above and not overkeying it. If the data was at the top I could fill down and do this by highlighting the column, go to blanks, put in = then ctrl enter and it works, but when I fill UP I can't get this to work since it changes the active cell. Below is an example of what I have on the left in a worksheet and on the right hat I need it to look like. How to fill up without overkeying the data above it. When I fill up it makes the whole column AA Category 1 total and that's not what I find.

unit 2 total
BB category 1 total
division 2 total
unit 2 total
division 2 total

I need to to look like this:

BB category 1 total
division 2 total
unit 2 total
BB category 1 total
AA category 1 total
division 1 total
unit 1 total

[code]....

## How I Can Minus Number From A Month?

Dec 2, 2008

In an excel file i have two fields,

Month to Start - is a combobox with 12 months, next is
Month to go back - is a textbox, here specifying number of months to go back.I need to store month names by minus the existing month - number in a textbox

eg: if Month to Start is 'September' and Month to go back is 2, then what i need is September & August in an array or separate variables.

How I can minus number from a month?

## Display Column Number Without Actually Manually Counting Across?

Sep 17, 2012

Is there any way i can display the columb number without actually manually counting across.The columbs are A to Z,AA to AZ,BA to BZ,CA to CZ & DA to DN....about 120 columbs.Is there a way to have the columb number diplayed by just placing the mouse cursor on the columb letter (not press though as it will select the whole columb..going to use for VLookup function

## Find Number With \$ Sign And Commas?

Jul 25, 2013

I have a number \$2,173,980.08 in my excel worksheet. I try to find it using Ctrl + F \$2,173,980.08 and excel couldn't find the number. What setting do I need to change in order for excel to find number with dollars sign and commas in it?

## How To Separate The Currency Sign From The Number

Feb 27, 2010

I have a file contains thousands of rows of purchasing order. the purchasing value is in different local currency,the data(number) format is "Accounting" .

Is there a way to separate the currency sign and the number into different column?

I need to the currency sign to be able to convert data to desired currency. But Excel read the data as number. so I was doing it row by row. Such a pain and not efficient.

## Return All Words Between Unit And Number Right Before \$ Sign

Sep 30, 2013

I'm trying to return only the following portion of the text from a large list.

So, I want to have just the following phrase appear in a column:

Original
AAM UNIT AAM HIGH 50 DIVIDEND 13 \$77,666,423 \$1,132,491

To
AAM HIGH 50 DIVIDEND

Original
AAM UNIT AAM HIGH 50 DIVIDEND 13 \$77,666,423 \$1,132,491

To
AAM HIGH 50 DIVIDEND

Original
FIRST TRUST UNIT FT HIGH DIV EQUITY 15 \$13,140,862 \$301,295

To
FT HIGH DIV EQUITY

So, I essentially, want any words that appear between "Unit" and the first number that appears before the \$ sign (in this case 13 and 15 respectively, but the numbers can be anything - "Unit" stays the same down the list).

## How To Find Number Of Mondays Between 2 Dates Minus Holidays

Feb 8, 2012

I have a formula to find the number of Mondays between 2 dates.

=SUMPRODUCT(--(TEXT(ROW(INDIRECT(E2&":"&F2)),"DDD")="THU"))

I now need to add in the variable of holidays and other days off. This is where I am loss. I do have a list of the weekdays that we did have class and a list of when we didn't

## When Starting Number Reaches Zero It Starts To Count In Minus

Mar 8, 2014

I am having trouble setting up my cycle count spread sheet. For instance if my starting number is 1000 and when it reaches 0 or below it starts to count in minus when I just want it to automatically reset to 1000

## Turn Number Into Text?

Feb 21, 2014

Is there a formula I can use that will look at the following in an excel cell Daily Numbers Report - Summary_2014-01-26.xls

and then convert that into the date value 41,300. And the same thing for all other cells with the same format...so if was Daily Numbers Report - Summary_2014-01-23.xls the formula would convert it to 41,297.

## Change Sign Of Number Based On Validation Dropdown In Another Column

Feb 21, 2014

This spreadsheet will be tracking sales and purchases. I want to be able to have any purchases formatted as an expenditure (negative sign or brackets) to show it is money out. Column C "Action" has a drop down with either Buy (infrequent) or Sell. I want to be able to have column I "Unit Price" be a negative number if the corresponding cell in the same row in Column C = "Buy". I do not have these prices formatted as currency as their are 2 different currency used and I don't know how to make the correct currency format appear automatically, though I do have a drop down validation column for which currency the transaction was in, so maybe that is possible. I know this is probably simple, but I don't spend that much time using Excel. I have some sample data in their for the moment.

## If Cell Has X Turn Into Number And Concatenate

Jul 4, 2009

Example is in the attch: Book11.xls. This formula works but if there is no number 4 then I don't want comma after 1, or 2, or 3, How avoid it:

results

1,2,3,4
1,2,
1,2,3,
3,4
1,
4
2,3,

(red , need to be removed)

## VB Macro That Will Turn Number To Date?

Jul 5, 2012

is it possible to have a VB macro that will turn a number to a date?

For example the numbers are like 21021967 that need to be turned into 21/02/1967

## Decimal Sign Replaced With ';' Sign

Dec 8, 2009

I'm trying to solve a strange problem in a piece of code.

I have a variable that is define as Double called STD. When i try to insert that variable in a formula the decimal sign (for me a comma "," because I'm Portuguese) gets converted to ";" (which is for me the separation sign for the expressions in excel formulas. ex: AND(A1>0;B1>0)=TRUE). The code is:

## Plus Sign And Equals Sign In Formulas

Sep 29, 2006

My boss uses the + symbol and the = symbol in his formulas eg "=+E3*E4" What is the advantage or difference in this as to just using "=E3*E4"

## Plus Sign After Equals Sign In Formula

Jan 10, 2008

In a formula, what effect does putting a plus sign after an equals sign? e.g.
=+((1+B8)^12)-1. I orginally assumed that it made sure that result the would always be positive but I was wrong.

## Carrying Over Negative Number To Next Column As Positive Number?

Aug 21, 2014

I go negative in one column I want it to show up in the next column as a positive number because when I add my income and subtract my bills and the negative from last month to get the what cash I'll have left it screws up because negative subtract a negative is a positive. So how do i get the sum of say B9 to from -\$5.00 to +\$5.00 into C4 so when i subtract C4 From my income it wont add to it.