To remove formula in Excel and keep text using the keyboard shortcut, follow these steps: Open the spreadsheet on your computer. Use your mouse to select all cells or a range.

If you type the formula as =FIXED(A2), Excel will round the number two digits to the left of the decimal point. Result 534.56 . There are two other methods to use the FIXED function.