canceling auto date update

[unexceller]

I use excel to create invoices. When I open up old invoices, th
original date changes to today's date. How do I stop this auto updat
function?

Thanks

 

[Roger Govier]

Hi
The cell where the date appears probably has the formula =TODAY() or
=NOW() which automatically recalculate when the sheet is opened.
Delete the formula and replace it with the date you require, then save.
When creating new invoices, typing Ctrl +; (Control plus the semicolon
key) will enter today's date into a cell for you.

--
Regards

Roger Govier


"unexceller" <[email protected]>
wrote in message
news:[email protected]...