When I open my past invoice it keeps changing date to todays date
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! |
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 Stop date changing to todays in Excel 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! |
All times are GMT +1. The time now is 06:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com