How do I show the formula in the formula bar and the actual calculation in the spreadsheet

[MoJo49]

I have created a spreadsheet and when I use the formular ‘sum’ the formula shows in the spreadsheet and not the calculation. The only way to show the calculation is to go to >Data>Calculate>Formula to Value. However when I do this the calculation also shows in the Formula bar so there is no way to know what actual formula I have used.

I am able to use the um function in a blank spreadsheet, but once I start to create something it disappears.

Any advice please

[robleyd]

Is View | Show Formula turned off?
Does your formula start with = ?
Have you formatted the cell(s) where the formula is as text?

[anon73440385]

Hello,

what you ask is the default:

Formula Bar: Shows the formula
Cell: Shows the result of the formula
(see cell C1 in the following screenshot)

If you see a formula in your cell and not the result of the evaluation of the formula, then you most likely have set option View -> Show Formula

**Warning** If you use `Data ->Calculate ->Formula to Value` you lose **all** formulas in the selected range. This function **replaces** all formulas by the current value of the evaluation. Hence this dramatically changes your document.
**Accidental remark** Never pre-format any cell as text (Format Code:`@`) **before** you enter a formula. Doing so will disable any input recognition and you'll get everything as text.

Hope that helps.