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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

[newbie] copying a date value 2
Macros within Excel 4
VALUES ARE DIFFERENT THAN CALCULATOR 4
Time calculations 6
Excel - Sliding decreasing scale (payroll tax calc) 2
adding actual numbers, not rounded 1
Spreadsheet reference in formula? 2
I need calculated time in a "real number" format 2

Back
Top