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?

Developer technologies Visual Basic for Applications
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.