| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula in Excel does not work until after I double-click inside c
I get this alot, and Ive searched everywhere for the answer.
No macros or hidden sheets active. Manual calculation is not on, it is set on Automatic. I've tried F9 for posterity, with nothing happening. I've tried CTRL-ALT-SHIFT-F9 also nothing. The cells Im working on have been imported from an external source, ie they are not hand entered but I dont think this is the issue. They are custom format though, i.e. h:mm:ss. Once I double-click on the cell and hit return the formula works but never before. PLEASE HELP!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| double click cell to show formula references | Excel Discussion (Misc queries) | |||
| Value won't show correctly in cell unless I double click formula, | Excel Discussion (Misc queries) | |||
| Double Click to see formula source data? Set up? | Excel Discussion (Misc queries) | |||
| Function does not work unless I double click the cell and push ent | Excel Discussion (Misc queries) | |||
| Double click xlsname in explorer doesn't work. | New Users to Excel | |||
Threaded Mode
