Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HO do I enter a number and have it always appear negative
Hi, i want all numbers in a range of cells to appear with a minus but want to
just enter the figures. Is this possible? Cheers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HO do I enter a number and have it always appear negative
1. Enter the numbers to the range
2. Once done. enter -1 to a ununsed cell and copy the cell 3. With the copy ON; select the entered range of cells 4. Right clickPasteSpecialselect Multiply OK. If this post helps click Yes --------------- Jacob Skaria "Shorichi" wrote: Hi, i want all numbers in a range of cells to appear with a minus but want to just enter the figures. Is this possible? Cheers |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HO do I enter a number and have it always appear negative
Possible with VBA to change the numbers to negative as you enter them.
Private Sub Worksheet_Change(ByVal Target As Range) Const myRange As String = "A1:A10" On Error GoTo endit Application.EnableEvents = False If Not Intersect(Target, Me.Range(myRange)) Is Nothing Then With Target If Application.IsNumber(.Value) And _ Left(.Value, 1) < "-" Then .Value = .Value * -1 End If End With End If endit: Application.EnableEvents = True End Sub This is sheet event code. Right-click on sheet tab and "View Code". Copy/paste the above into that sheet module. Edit myRange to suit. Alt + q to return to the Excel window. Gord Dibben MS Excel MVP On Wed, 10 Jun 2009 19:24:09 -0700, Shorichi wrote: Hi, i want all numbers in a range of cells to appear with a minus but want to just enter the figures. Is this possible? Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter credit (negative number) in sales template | Excel Discussion (Misc queries) | |||
ENTER NEGATIVE AMOUNT | Excel Discussion (Misc queries) | |||
How do you enter a negative time number in Excel? | Excel Discussion (Misc queries) | |||
How do I enter a negative number in unit price column? | Excel Discussion (Misc queries) | |||
2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions |