N
Naas
how can you format a cell so that all numbers entered
will always be a negative number
will always be a negative number
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
could only be done with VBA (using an event procedure). Try the
following 8put this macro in your worksheet module - not in a standard
module):
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Me.Range("A1:A100")) Is Nothing Then Exit Sub
On Error GoTo CleanUp:
With Target
If .Value <> "" and isnumeric(.value) Then
Application.EnableEvents = False
if .value > 0 then
.value = -.value
end if
End If
End With
CleanUp:
Application.EnableEvents = True
End Sub
could only be done with VBA (using an event procedure). Try the
following 8put this macro in your worksheet module - not in a standard
module):
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Me.Range("A1:A100")) Is Nothing Then Exit Sub
On Error GoTo CleanUp:
With Target
If .Value <> "" and isnumeric(.value) Then
Application.EnableEvents = False
if .value > 0 then
.value = -.value
end if
End If
End With
CleanUp:
Application.EnableEvents = True
End Sub
A
Andy B
Hi
Another option is to use Data Validation. This can be set to flag whenever a
positive number is input. If you set the Allow box to Custom and the formula
to =A1<0 (for cell A1)
This does not stop people pasting in values above 0, however.
Andy.
Another option is to use Data Validation. This can be set to flag whenever a
positive number is input. If you set the Allow box to Custom and the formula
to =A1<0 (for cell A1)
This does not stop people pasting in values above 0, however.
Andy.
A
AlfD
Hi!
The function abs() returns the positive value of whatever is entered
Therefore =-abs(A1) in B1 would ensure that, if a number were entere
in A1, the result in B1 would be negative but of the same (absolute
size as A1 (zero excluded, of course).
Al
The function abs() returns the positive value of whatever is entered
Therefore =-abs(A1) in B1 would ensure that, if a number were entere
in A1, the result in B1 would be negative but of the same (absolute
size as A1 (zero excluded, of course).
Al