Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i set up a column with negative values automatically?
i am having to enter negative numbers in a single column. is there a way to
do so without having to enter all of them one by one manually? is there a command that will automatically make my entry negative? |
#2
|
|||
|
|||
Lets say you enter all the numbers in your column as positive (without the -
sign). Then enter -1 in an unused cell somewhere. Copy this cell and paste it special into all your positive numbers with the multiply option checked. This will make all your numbers negative in one fell swoop. -- Gary's Student "pooperdoodle" wrote: i am having to enter negative numbers in a single column. is there a way to do so without having to enter all of them one by one manually? is there a command that will automatically make my entry negative? |
#3
|
|||
|
|||
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit: Application.EnableEvents = False With Target If .Column = 2 Then .Value = Abs(.Value) End If End With ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "pooperdoodle" wrote in message ... i am having to enter negative numbers in a single column. is there a way to do so without having to enter all of them one by one manually? is there a command that will automatically make my entry negative? |
#4
|
|||
|
|||
One way
In a blank cell enter -1 copy highlight range with numbers needing correction Editpaste special and click the radio button for multiply HTH "pooperdoodle" wrote: i am having to enter negative numbers in a single column. is there a way to do so without having to enter all of them one by one manually? is there a command that will automatically make my entry negative? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
column values to a cell with comma seperated | Excel Worksheet Functions | |||
look up same values in coumn1 and calculate values in 2nd column | Excel Worksheet Functions | |||
Column Chart with 2 values in each column | Charts and Charting in Excel | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
Removing duplicate values in a column | Excel Worksheet Functions |