Is it possible to set the numberformat in a cell/column using either Excel or VBA so that:
- if I enter a formula (anything starting with =) Excel will calculate the formula (and not interpret it as just text)
- if I enter a value, for example 5.80, Excel will store it as text?
I'm having a problem where I want all user input to be stored as text, but users should also be able to enter formulas. If I set the numberformat to text, formulas aren't interpreted. If I set the numberformat to general, values are stored as numbers.
Here is my version.
Format all cells in that sheet as
Text
. This code usesApplication.Evaluate()
to evaluate all formulas and store the result as text.