When I open my past invoice it keeps changing date to todays date

  • Thread starter Stop date changing to todays in Excel
  • Start date
S

Stop date changing to todays in Excel

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 [email protected]

thanks!
 
R

Roger Govier

Hi

The cell where the date appears probably says =TODAY()
That is a volatile function, which will re-calculate on each opening of
the sheet, and therefore will alter.

Instead of having the formula in the cell, press CTRL ; (hold down the
control button and press semicolon) and this will insert today's date
into a cell as a fixed value.

Regards

Roger Govier
 
R

Richard Buttrey

On Fri, 7 Oct 2005 07:53:09 -0700, "Stop date changing to todays in
Excel" <Stop date changing to todays in
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 [email protected]

thanks!
Click to expand...

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
__________________________
 
Top