On Fri, 7 Oct 2005 07:53:09 -0700, "Stop date changing to todays in
Excel" <Stop date changing to todays in
wrote:

When I open a previously created invoice in Excel, it automatically changes
the date of the invoice to todays date. I dont want that, I want to see when
I billed the guy, I want to stop this function, how do i do that?
email me at

thanks!

As well as Roger's suggestion, you might want to consider a VBA macro
attached to the Workbook Save event. You could make this change the
=today() cell to text.

e.g.

Sub HardcodeDate
Range("yourdatecell").Copy
Range("yourdatecell").PasteSpecial (xlPasteValues)
End Sub
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________