Haha....it works well, very good. thank you very much Allllen

hui


"Allllen" ...
OK try this instead then:

A B C
1 1978-9-22 =TEXT(A1,"yyyy-m-dd") =FIND("-",B1)
2

Please rate me.

--
Allllen


"hui" wrote:

when I set Column as TEXT, the content changes and look like number, such
as
A1(1978-9-22) change 28734. may I avoid it?

thanks




"Allllen" ...
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