#VALUE about function Find

[Guest]

good point and I agree that this is totally messed up, but if you go back to
his original question all i did was make sure that he got it in the format he
was trying to enter without having to type it in again

 

[hui]

Yes, I am also confused by the huge and unsoted date data. I just wanna deal
with it easily as soon as I can with worksheet function. anyway excel is a
strong office assistant. thanks for your suggestion.

hui

 

[hui]

Yes, I am also confused by the huge and unsoted date data. I just wanna deal
with it easily as soon as I can with worksheet function. anyway excel is a
strong office assistant. thanks for your suggestion.

hui

 

[Bob Phillips]

I am not referring to your response Allllen, I am highlighting the points I
made earlier to the OP.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Bob Phillips]

I am not referring to your response Allllen, I am highlighting the points I
made earlier to the OP.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Bob Phillips]

BUT WHAT YOU HAVE NOW ACCEPTED AS A SOLUTION IS NONSENSE, IT DOES NOT SORT
ANYTHING.

All you will get is the number 5 for every row with a number.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Bob Phillips]

BUT WHAT YOU HAVE NOW ACCEPTED AS A SOLUTION IS NONSENSE, IT DOES NOT SORT
ANYTHING.

All you will get is the number 5 for every row with a number.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[hui]

no, I can sort the column, and deal with data with VBA.

hui