Use =now(), then copy it and paste it back using one of the paste options to paste the value only rather than the formula (I think it's under "paste special").
Yuri (sorry for the top post - I'm in a hurray) On 31/05/06, Nick Rout wrote:
I want to use a spreadsheet to record some data. I want to be able to insert the current date and time in the first column, ie the date and time of the entry.. I can use =now() to insert the current date and time, but that gets updated, ie I want it to stay at the time of entry, but it keeps being, well, now. Any other ideas how I can permanently record the current time without axtually typing the whole lot in? -- Nick Rout
