Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, so I have a spreadsheet that I use as a timecard, and what I'd like to
do is the following. I already have data entered in these cells as 0 so that when an employee does not edit the field, the value is 0. My problem comes when an employee enters the value in the wrong field. Say an employee means to enter 7 hours in field N14. He accidentally enters the data in N13, and then deletes the value, and enters it in N14. However, now instead of 0 in cell N13, there is no value. What I would like to happen is to have excel automatically make cells within a specified range default to 0 if they're data is deleted. Any hints? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make default page size as A4? | Excel Discussion (Misc queries) | |||
How do I make make comment format default? | Excel Discussion (Misc queries) | |||
How do I make a default setting so veritical is on the top? | Setting up and Configuration of Excel | |||
Make the default always with a Footer | Excel Discussion (Misc queries) | |||
make a conditional format the default | Excel Discussion (Misc queries) |