Timestamping Individual Rows

[sk0ut]

I am cataloging my film library and would like to timestamp the date in which I enter titles. I am not familiar with VBA and so was using the function, "=TEXT(TODAY(),"mm-dd-yy")" until I realized the entire column is affected despite entering the function in each row. So if I entered the function, it would come up correct, "06-02-13," but the entire column would then change to reflect this. Am I not using the right function, or am I not using it correctly? Any help would be appreciated. Google is not turning up anything useful.

[AndyLitch]

A function is dynamic/volatile so it will keep calculating the value of today... On any given day there is only one value for today

You have to use VBA really ... Try the following in the worksheet code module

Please Login or Register  to view this content.

[sk0ut]

Thanks for the quick response. Is there a way to force it to calculate in one instance? If not, is there another way to timestamp cells?