Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default 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.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
  #3   Report Post  
JulieD
 
Posts: n/a
Default

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I change an excel template into a "workbook" joyce Excel Discussion (Misc queries) 5 April 14th 05 04:38 PM
Excel should have a quick and simple "change case" function like . NinaSvendsen Excel Worksheet Functions 1 January 28th 05 03:15 PM
how do I change the text case of imported data in excel? ArtLene Excel Discussion (Misc queries) 1 January 26th 05 07:08 AM
change the default word in the insert comment option in excel excel Setting up and Configuration of Excel 2 December 24th 04 12:51 PM
Can you change the defaults for Excel ? Nino Richards Excel Discussion (Misc queries) 1 December 15th 04 04:35 PM


All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"