| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula doesn't work unless hit enter again
Try selecting all the cells
Edit|Replace What: = (equal sign) with: = replace all Maybe it'll wake up excel's calculation engine. Bobby wrote: I have to select Each cells with a function, than put my cursor in the formula bar and press enter. The excel option 'automatic calculation' is on and was always on before? Also, all cells are in 'numbers' format...not text. Thanks ! -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula doesn't work unless hit enter again | Excel Discussion (Misc queries) | |||
| enter doesn't work with sumif | Excel Worksheet Functions | |||
| What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
| alt+enter does not work | Excel Worksheet Functions | |||
| Excel, how do I get ALT F C to work the same as ALT F Enter C ? | Excel Discussion (Misc queries) | |||
Threaded Mode
