Static Date Function

[ssdsibes]

Hi
I have found threads that explain that if you want a to use the now() or today() function but make it static, you have to put a code in the worksheet relating to it.
I have read quiet a few threads, but i can't seem to make my code work.

I need to format column A to have the date format in it. I have a event procedure that puts Now() when run in Column A and I think i need to add the following code to the worksheet to make it static.

Please Login or Register  to view this content.

any help greatly appreciated.

[DonkeyOte]

You mean ?

Please Login or Register  to view this content.

but that would of course be overriding whatever was entered into Column A that invoked the event in the first place...

[ssdsibes]

Column A contains only the Now() function, and after running your code, it seems to work for me, and the cell now contains the date as text, and not the formula now() that was previously being held from my event procedure.
thanks for your help