space bar to clear a cell we get #value!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when we use the space bar to clear a cell we get a #value! error in the other
cell that carries the formula. This just started happening. If we use the
backspace key it works fine.
 
Hi Andi,
when we use the space bar to clear a cell we get a #value! error in the other
cell that carries the formula. This just started happening. If we use the
backspace key it works fine.
Click to expand...

Excel cannot do math with cells that contain text and hitting the spacebar
effectively enters text into a cell. This has always been the case. Hit the del
key to clear a cell.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
Back
Top