Skip to Content
Special Edition Using® Microsoft® Office 2003
book

Special Edition Using® Microsoft® Office 2003

by Ed Bott, Woody Leonhard
September 2003
Beginner to intermediate content levelBeginner to intermediate
1368 pages
56h 14m
English
Que
Content preview from Special Edition Using® Microsoft® Office 2003
714
Chapter 25 Advanced Worksheet Formatting
Troubleshooting
Stopping Automatic Conversions
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?
No, unfortunately. When Excel sees a value that looks like a date or time or scientific nota-
tion, 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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Special Edition Using Microsoft® Office XP

Special Edition Using Microsoft® Office XP

Ed Bott, Woody Leonhard
Special Edition Using Microsoft® PowerPoint® 2002

Special Edition Using Microsoft® PowerPoint® 2002

Patrice-Anne Rutledge, Tom Mucciolo

Publisher Resources

ISBN: 0789729555Purchase Link