Why is my number stored as text in Excel? Excel doesn’t convert numbers written in text into digits if you import data from another source because of the default setting. That being said, even ...

Read: How to combine text from multiple cells into one cell in Excel How do I convert text to numbers in Excel? Once you paste the text (containing numbers) in the cell, you can change the cell ...

If the DAT file you're trying to open is text, you can convert the file into text in the Microsoft Excel program by first saving it as a CSV file.

How to Convert Excel to Text & Set Column Width. Each Microsoft Excel worksheet is broken up into cells. Each cell is part of a column.