Learn how to fix text-formatted numbers. This is also known with an error message of the number in this cell is formatted as text. Allow me to show you how to convert data to numbers.br br Sometimes, numbers in a worksheet are formatted and saved in cells as text instead of numbers, which can complicate calculations or result in muddled sort orders. When you import or copy data from a database or another external data source, this problem can occasionally arise.br br In the cell, numbers that are formatted as text are left-aligned rather than right-aligned, and they frequently have an error indicator.br br There are 2 basic ways to get around this and they are as follows.br br METHOD 1: Convert text-formatted numbers by using Error Checkingbr Technique 1 - Single cellbr select single cell and convert it to number.br br Technique 2 - Range of cellsbr Select first cell that is text and drag down column.br br Technique 3 - Large range of cellsbr Select first cell that is text, and drag across number table.br br Technique 4 - All cells on a worksheetbr Select first cell that is text, and press Ctrl + Abr br br METHOD 2: Convert text-formatted numbers by using Paste Specialbr 1) Enter 1 in any empty cell.