Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I change an excel template into a "workbook" | Excel Discussion (Misc queries) | |||
Excel should have a quick and simple "change case" function like . | Excel Worksheet Functions | |||
how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
change the default word in the insert comment option in excel | Setting up and Configuration of Excel | |||
Can you change the defaults for Excel |
Excel Discussion (Misc queries) |