How To Stop Excel From Changing Numbers
By
SpreadCheaters
Page last updated:
08/10/2022 |
Next review date:
08/10/2024
Excel can be very annoying at times. Whenever you type in a number a date instantly shows up. But there is a way to lock in the input of the cell.
Step 1 – Before typing in any input, add in an apostrophe (‘) right before it.
Do make sure that an apostrophe sign is added right before the input of the cell to ensure that the formatting wouldn’t change
Step 2 – Press Enter
Pressing Enter will return the output of the formula. As you can see, the apostrophe sign is omitted in the output of the formula.
