Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • DownloadDownload
  • PrintPrint

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?


  

You are currently reading a PREVIEW of this book.

                                                                                        

Get instant access to over
$1 million worth of books and videos.

  

Start a Free Trial