custom validation
 

When a cell is equal to *.0000 I want there to be a warning. So for instance
if A1 was 711200.0000 there should be an error but if it was 711200.4720.197
or just 711200.4720 it should not give an error. Thanks!

Hi
try
=RIGHT(A1,5)<".0000"
as custom validation rule (Menu: 'Data - Validation'

--
Regards
Frank Kabel
Frankfurt, Germany
"tjb" schrieb im Newsbeitrag
...
When a cell is equal to *.0000 I want there to be a warning. So for
instance
if A1 was 711200.0000 there should be an error but if it was
711200.4720.197
or just 711200.4720 it should not give an error. Thanks!

I tried that but it doesn't work, any other ideas? Could it be because of
cell formatting?

"Frank Kabel" wrote:

Hi
try
=RIGHT(A1,5)<".0000"
as custom validation rule (Menu: 'Data - Validation'

--
Regards
Frank Kabel
Frankfurt, Germany
"tjb" schrieb im Newsbeitrag
...
When a cell is equal to *.0000 I want there to be a warning. So for
instance
if A1 was 711200.0000 there should be an error but if it was
711200.4720.197
or just 711200.4720 it should not give an error. Thanks!

Hi
what have you entered exactly and what cell are you using for it

--
Regards
Frank Kabel
Frankfurt, Germany
"tjb" schrieb im Newsbeitrag
...
I tried that but it doesn't work, any other ideas? Could it be because of
cell formatting?

"Frank Kabel" wrote:

Hi
try
=RIGHT(A1,5)<".0000"
as custom validation rule (Menu: 'Data - Validation'

--
Regards
Frank Kabel
Frankfurt, Germany
"tjb" schrieb im Newsbeitrag
...
When a cell is equal to *.0000 I want there to be a warning. So for
instance
if A1 was 711200.0000 there should be an error but if it was
711200.4720.197
or just 711200.4720 it should not give an error. Thanks!

tjb,

Use the custom formula:

=MID(A1,FIND(".",A1)+1,4)<"0000"

HTH,
Bernie
MS Excel MVP

"tjb" wrote in message
...
When a cell is equal to *.0000 I want there to be a warning. So for
instance
if A1 was 711200.0000 there should be an error but if it was
711200.4720.197
or just 711200.4720 it should not give an error. Thanks!