When you import information into Microsoft Excel, the program attempts to convert all data to numeric values. This is because Excel is primarily a spreadsheet program designed for working with numbers. However, sometimes you may want to keep the imported data as text values. For instance, if you are importing a list of product names, you may want to keep the product names as text so that you can easily reference them in your worksheets.
To convert imported information to text values in Excel, you can use the following steps:
Your imported data should now be displayed as text values in your Excel worksheet.