Thread: Date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Date

copy/paste values or use a macro
range("a1")=date

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
I have been using this "=IF(L2="","",TODAY())" in order to date a field
once there is information added to another,the problome is that it
changes the date everytime the document is open. How would I do the
date so once it's there it becomes fixed?

TIA