The Datevalue in fx fuction or in the formula. It's expect the text date.
example: in Datevalue you have to enter "1/1/2006" . It will not work when
you enter A1

"art" wrote:

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"