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

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.

wrote:

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.

--

Dave Peterson

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.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"
wrote in message ...
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.