Is there a way to use the space bar to delete?
 

When I use the space bar to clear out a cell included in a time formula
I get a #value! Is there a way to keep this from happening?


--
Jolene
------------------------------------------------------------------------
Jolene's Profile: http://www.excelforum.com/member.php...o&userid=10223
View this thread: http://www.excelforum.com/showthread...hreadid=274956

Hi Jolene,

Never use the space key to "clear" cells. It does not clear them, it enters
a space. Computers think that is something totally different.

use the Del key instead

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Jolene" wrote in message
...

When I use the space bar to clear out a cell included in a time formula
I get a #value! Is there a way to keep this from happening?


--
Jolene
------------------------------------------------------------------------
Jolene's Profile:
http://www.excelforum.com/member.php...o&userid=10223
View this thread: http://www.excelforum.com/showthread...hreadid=274956