change date in excel from today to original date of file

N

Nelson

I have an invoices created in Excel 2003 that automatically fills in today's
date when I open the invoice. However, every time I open that invoice at some
future date, for example to record payment, the date changes to the current
date. Is there a way to lock the original date, say after printing so that
the original date of the invoice is always displayed?
I see a lot of chatter on the web about “VB†solutions but don’t understand
any of it.
Thanks, Nelson.
 
D

David Biddulph

If you want to avoid a VBA solution, you could use Control semi-colon to
enter the current date.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top