Troubleshooting

Stopping Automatic Conversions

After importing data into a worksheet from a text file or a database, you notice that Excel has converted some data to date serial values and others to scientific notation. You want the information to appear in your worksheet exactly as it did in the database. Is there any way to change it back?