1) Format cell A1 as text (under Format Cells)
2) Enter 1978-9-22
3) Now your find function will work. The down side of this is that cell A1
is now a text and not a number (means Excel won't be able to think of it as a
date).

Instead of formatting cell A1 as a text, you could just type '1978-9-22
(with the apostrophe). That has much the same effect.

If you can avoid having it as a text I would recommend leaving this as a
date like bob suggests because it is much more flexible like that. Depends
what you want to do with it of course.

--
Allllen


"hui" wrote:

I set A1="1978-9-22", B1="find("-",A1)" and return, but B1 shows #VALUE!,
why? How can I resolve it? thanks in advance.

A B C
1 1978-9-22 =find("-",A1)
2
3


hui