Instead of formatting as text, enter your number preceded by a single quote

The numeric string being text it cannot be used in some formulas as a number, BUT all arithmetic operations will coerce the text value to a number
In the other cases, when you refer to the cell use A1+0 to coerce to a number

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post