Excel will not allow me to change a numerical figure in a specifi.

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

Guest

Excel will not allow me to change a numerical figure in a specific cell.
I've tried deleting it & typing over it, but when the cursor is moved to the
next cell the original figure magically appears again.
 
It kind of sounds like you have an event macro running.

If you open excel in safe mode:
close excel
windows start button|Run
excel /safe

Does it happen?

If no, you'll want to talk to the developer to find out why he or she did this.

===
Another possibility--if you're always typing the same number, maybe Autocorrect
is kicking in. (but if you type in any number and this happens, it's probably
not autocorrect).

Tools|autocorrect options|autocorrect tab|look for those characters that are
getting corrected.
 
Hi

there's probably worksheet_change code that sets the cell back to that
figure, right mouse click on the sheet tab, choose view code, do you see
anything call
Private Sub Worksheet_Change(ByVal Target As Range)

if so, on the lines between this line and the END SUB line put an apostraphe
'
at the front of each line
use ALT & F11 to switch back to your workbook and try changing the cell
value now.
if the code doesn't make sense to you, copy & paste it into your reply and
we'll try and explain what its doing.
 
Back
Top