|
|
#1
11-20-2018, 01:24 PM
|
|||
|
|||
when press enter, cell value rolls to zero
I copy a cell value from one worksheet (it is a sum formula). I paste the value into a different sheet in the same workbook. If I arrow out of the cell or click in a different cell, all is well, but if I hit return, the next cell down is selected and the value in the target cell goes to zero. If I return to the target cell and press return, the value stays.
I've never seen this behavior before.  Excel 365. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Starting Excel message Cell(press ESC to cancel) (x%) | Nednil | Excel | 0 | 10-06-2017 02:57 PM |
 Mail Merging labels for paper rolls in Word 2007
|
blackystrat | Mail Merge | 1 | 12-24-2015 03:21 AM |
| text box appears after I press enter/try to write in bullet form | topgunitsme | Word | 1 | 08-13-2014 03:26 PM |
| how to enter what i want in cell | tasuooooo | Excel | 4 | 07-23-2012 05:45 AM |
| Highlighted text won't delete - when I press enter | Gague | Word | 2 | 07-09-2010 12:53 PM |
Windows 10 
Office 2010 64bit
Threaded Mode