Save cell display but not calculation

[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 Guillett]

change the formula to values by copy\paste or a macro to do it for you.

 

[wellzy]

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.

 

[Don Guillett]

select cell(s)
copy
select same cell(s)
edit>paste special>values
the icons may be avail on your toolbar

 

[Ardus Petus]

If you hit Ctrl+; , Excel will enter today's date in active cell, without
any formula

HTH