XLMind Data · Text & Numbers

Text to Numbers

Converts numbers that are stored as text, including ones with a leading apostrophe, into real numbers so they can be used in calculations.

What it does

Converts numbers that are stored as text, including ones with a leading apostrophe, into real numbers so they can be used in calculations. Values that would lose a leading zero, such as a phone number, an identity number or a product code, are protected and reported. A dialog lets you choose Safe, Force or Keep as text. The change happens in place and you can undo it.

Your data is processed on your own computer. Your Excel contents are never shared with AI services.