This link of John McGimpsey should help:

http://www.mcgimpsey.com/excel/timestamp.html


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"FARAZ QURESHI" wrote in message
...
Working upon a project requiring a column to be recording date/time when
an
entry is made in the row. Sort of Now() function with dates being
converted
to text right upon latest entry.

Lets say I enter an entry in A5, C5 shows Jan 01, 07 (Current Date);
Next day when I enter an entry in A6 & A7, C6 & C7 reflects Jan 02, 07;