| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
switching between formula display and value
F2 simply put you into edit cell mode
"layvanai" wrote: Thanks Mike it worked, but I don't understand what F2 does. Layvanai "Mike H" wrote: The cell is probably text Try selecting the cell Format|Cell|Number and select general Tap F2 and then enter Mike "layvanai" wrote: The formula written as =IF('Boiler 3'!$M$15<"",'Boiler 3'!$M$15,"") does not display the result in the cell even after switching the sheet between formula and value (ctrl `). This same formula works in other areas of the same worksheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| switching x axis | Charts and Charting in Excel | |||
| Switching Between Showing Formula Or Actual Result In A Cell ? | New Users to Excel | |||
| switching the worksheet? | Excel Discussion (Misc queries) | |||
| VBA Switching Between Macros | Excel Discussion (Misc queries) | |||
| Switching cells | Excel Discussion (Misc queries) | |||
Threaded Mode
