Don't know what you're tring to do but the DATEVALUE function argumtent MUST
be a TEXT value. For example:

A1 = June (TEXT entry)

=DATEVALUE(A1&" "&1)

Returns the serial date for June 1 2006 = 38869

Formatted as a DATE = 6/1/2006

Biff

"art" wrote in message
...
on A1 i type 1/1/06 (date.Jan.1.2006)
then B1 i click fx function button click Datevalue
pop-up form appear and under beside the Date_text : A1 :
and from there you can see the = 38718 (my expected answer) and then hit
enter.
Arggghhhh. on cell B1 i see this #VALUE!.
Where does this come from, since the pop-up form had already shown to me
the
correct result and then from nowhere somebody place in cell B1 the
#VALUE!...any tricks behind this?
--
"Simple things amuse simple minds"