Troubleshooting
Stopping Automatic Conversions
Q1: | After importing data into a worksheet from text files and databases, I noticed that Excel converts some data to date serial values and other data to scientific notation. I want the information to appear in my worksheet exactly as it did in the database. Is there any way to change it back? |
A1: | No, unfortunately. When Excel sees a value that looks like a date or time or scientific notation, either when you type a value into a cell or when you import a database, it converts the value automatically as you type or import. There is no way to reverse this conversion. If you have serial numbers that use the format ##X####, where each # is a number and the X is a letter, Excel converts any serial number ... |
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.