custom validation

[tjb]

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!

 

[Frank Kabel]

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

 

[tjb]

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

 

[Frank Kabel]

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

 

[Bernie Deitrick]

tjb,

Use the custom formula:

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

HTH,
Bernie
MS Excel MVP