date formulas

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

I have designed a excel invoice for a small busines I
run. One of the formula's I have used is =Now()which puts
the current date on the spreadsheet.

Where my problem occurs is, if several months later I am
asked by a customer for a dulicate copy of the invoice
and I retreive the invoice the current date is put in.
Question, is there anyway I can retreive an invoice and
still maintain the original date.

Doug
 
Doug,

One suggestion:

When you save the original invoice do a Copy, Paste
Special|Values on the cell that contains the invoice date.

HTH,
Fred
 
Doug

You could use Ctrl and ; to enter the current date. This will stay as is. ie
not change each time you open the worksheet.

Andy.
 
Back
Top