View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default In a formula, copy the value and formatting of another cell

see

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


In article ,
papakfl wrote:

Essentially, I want to date and timestamp an entry in a spreadsheet. So, I
want to copy the date and time from the @now() function as a value only.
That is, they won't change for a specific entry the next time I use the
spreadsheeet and make an entry.