Lookup the function FormatDateTime in help.
-----Original Message-----

hello,

I have a number that is actually a date, now i want to
convert this
number back to a date, i have tried to do that with cell
formats en
with the macro recorder, but the value in the cell
remains the number
until you click on it several times. It must be converted
at once
because several functions are depending on it.

Regards,
Niek


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.