Share via

Can Excel VBA identify numbers stored as text, and can it change them to numbers automatically?

Alastair Ching 0 Reputation points
2025-02-21T14:43:13.2833333+00:00

Excel identifies numbers stored a text, with a green mark and an associated error button

If you tick the error button, you can Excel to change the numbers to be stored as numbers

Can this happen automatically?

Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,496 questions
0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.