View Single Post
  #1   Report Post  
JDP
 
Posts: n/a
Default How do I keep the date from being updated every day

I use the following formula in an Excel worksheet:
=IF(L2=0,"",TODAY())

I would like for it to stay the original date it puts in there. Right now I
have to copy the entries and paste them back as values so it won't change the
date tomorrow when I start the spreadsheet again.