| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula works when pasted, but not when typed
I have encountered a bizarre Excel 2003 bug that crops up from time to time.
Sometimes, a formula that is typed into a cell does absolutely nothing, i.e., Excel does not evaluate it. If I type the same formula into another cell and then do a copy and paste, the formula works in the same location where it previously failed to work. Here's the latest formula that I was using where I encountered this problem. =SUBTOTAL(103,$A$3:$A$64000) I've verified that the cell format is "General" in both cases. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to use text typed in a cell C27 in formula Ex:Vlookup(C27.. | Excel Worksheet Functions | |||
| Typed or pasted text in a cell appears as #### | Excel Discussion (Misc queries) | |||
| formula typed contains an error | Excel Worksheet Functions | |||
| carriage return that works when pasted into a text file (eg. Notep | Excel Discussion (Misc queries) | |||
| How do I apply a formula to #s already typed in a series of cells | Excel Worksheet Functions | |||
Threaded Mode
