Hi Niek

it was on a excel work sheet that i had already on my pc and this function
convert genral text to date format as =datefmt(a1), and it works also !!!

"Niek Otten" wrote:

Where did you find that? It is not one of the built-in Excel functions (at
least not in the English version)

--
Kind regards,

Niek Otten

"Vafa Ashrafi" <Vafa wrote in message
...
how it works in excel "=datefmt()"?