Save cell display but not calculation

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

I am using an Excel spreadsheet for payroll. I input the times and
Excel calculates hours worked. Here's my problem. When I open the
workbook each week it inputs the dates automatically. When I am done it
saves the dates correctly. My problem is when I open an old payroll
spreadsheet. It changes the dates to the current dates because of the
formula. Is there anyway to save (or embed) the dates, but not the
formula for that cell. That way when I open my old payroll spreadsheets
it will not change the dates to the current payroll?
 
don

thanks for the replay. i am confused by what you are saying. how do i
change it to a value. i will do some research in the help section again.
 
select cell(s)
copy
select same cell(s)
edit>paste special>values
the icons may be avail on your toolbar
 
If you hit Ctrl+; , Excel will enter today's date in active cell, without
any formula

HTH
 
Back
Top