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.

Navigate to the "Number" group within the "Home" tab in Excel. Click the small arrow beside the "Number Format" box. Click "Text" to convert your cells to text formatting.

Using the Excel Text to Column feature, you can choose how to split the column up, fix the width, or split at each comma, period, or other characters.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

You can convert OpenOffice.org text documents to Excel with the text import tool. Save the text document with the .txt file extension, open it in Excel and save it as an Excel spreadsheet.