Data Valadation Formula Needed
 

I want to limit data entry to two decimal places only. What would the
formula be?

Data Valadation Formula Needed
 

=MOD(A1*100,1)=0

HTH
--
AP

"Phil H" a écrit dans le message de
...
I want to limit data entry to two decimal places only. What would the
formula be?

Data Valadation Formula Needed
 

Ardus,

I think I've mistated the problem. Column E has currency values (dollars),
given into cents (hundreds). Example: $123.89. Column F is a balance
column with the following formula: =F22+E23, as would be located in F23. I
want to restrict entries in column E to two decimals, and prevent any
rounding in column F. What would the approach be? I thought data
validation, but can't get it to work with the MOD function.

Thanks, Phil

"Ardus Petus" wrote:

=MOD(A1*100,1)=0

HTH
--
AP

"Phil H" a écrit dans le message de
...
I want to limit data entry to two decimal places only. What would the
formula be?

Data Valadation Formula Needed
 

The formula I gave you
=MOD(E23*100,1)=0
applies to Data validation of column E

HTH
--
AP

"Phil H" a écrit dans le message de
...
Ardus,

I think I've mistated the problem. Column E has currency values
(dollars),
given into cents (hundreds). Example: $123.89. Column F is a balance
column with the following formula: =F22+E23, as would be located in F23.
I
want to restrict entries in column E to two decimals, and prevent any
rounding in column F. What would the approach be? I thought data
validation, but can't get it to work with the MOD function.

Thanks, Phil

"Ardus Petus" wrote:

=MOD(A1*100,1)=0

HTH
--
AP

"Phil H" a écrit dans le message de
...
I want to limit data entry to two decimal places only. What would the
formula be?

Data Valadation Formula Needed
 

Ardus,

You are correct. In this case, I need to restrict intries in a range of
cells, say E5:E23. The below code looks for true when values are 1 through
12. How could it be modified to say the number of decimals must be two? If
I can get this to work, I have the solution. Thanks much for your help. Phil

' Between 1 and 12?
If cell < 1 Or cell 12 Then
EntryIsValid = "Valid values are between 1 and 12."
Exit Function
End If




"Ardus Petus" wrote:

The formula I gave you
=MOD(E23*100,1)=0
applies to Data validation of column E

HTH
--
AP

"Phil H" a écrit dans le message de
...
Ardus,

I think I've mistated the problem. Column E has currency values
(dollars),
given into cents (hundreds). Example: $123.89. Column F is a balance
column with the following formula: =F22+E23, as would be located in F23.
I
want to restrict entries in column E to two decimals, and prevent any
rounding in column F. What would the approach be? I thought data
validation, but can't get it to work with the MOD function.

Thanks, Phil

"Ardus Petus" wrote:

=MOD(A1*100,1)=0

HTH
--
AP

"Phil H" a écrit dans le message de
...
I want to limit data entry to two decimal places only. What would the
formula be?