It displays contents of the active cell.
yes
ways to open a display dialog box
Saving a file will not display the dialog box.
The answer will display in the cell itself.
To display the formula, not its results, in a cell, a user can choose a format for "text."
Formula
stuff
formula
Click on the cell to view the formula in the formula bar at the top of the screen. If you would like to display the formula as text in a cell, instead of seeing the results of the formula, enter an apostrophe (') in front of the equal sign (=) of the formula. That will tell Excel to display the cell contents as text and not try to calculate the formula. To display all formulas at once, press and hold the Ctrl key and then press the ` key, which is in the top corner of your keyboard. There is also an option in the View menu to display formulas.
It depends on the length of each word. The number of words does not matter; the limit is the number of total characters, including spaces. The maximum length of cell contents (text) is 32,767 characters. Only 1,024 display can display in a cell, but all 32,767 characters display in the formula bar.
Click on the cell. Then press F2 or click in the formula bar to edit the formula.
By going to the insert tab, text box.