Stop Excel Transformations of Imported Data (2 Simple Tips)

Add to Favorites
Author: | Edits: don

Prevent Excel from changing data that you import, including long numbers, text that looks like dates but is not a date, and more.

I'll show you 2 ways to keep your data safe, including a way to have granular control over how the data and is imported, column-by-column.

Resources

Import CSV Files (Microsoft Resource)

TeachExcel Online Courses


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Print Only Specific Parts of a Worksheet in Excel
Tutorial: In Excel you can select parts of a worksheet to print while ignoring all of the other data...
Basic Web Query in Excel - Import Data from the Web into Excel
Macro: Import data from the web into Excel with this macro. This is a basic web query macro that ...
Import a Worksheet from One Workbook to Another in Excel
Tutorial: In Excel, you can quickly copy an entire worksheet from one workbook to another workbook....
Stop Excel from Changing Numbers to Dates or Anything Else
Tutorial: How to stop Excel from automatically changing numbers into anything other than what you ty...
Performing Calculations in Excel - Order of Operations Explained
Tutorial: In this tutorial I am going to cover how to perform calculations in Excel. Calculations in...
Filter Data to Show the Bottom 10 Percent of a Data Set in Excel - AutoFilter
Macro: This free Excel macro filters a data set to display the bottom 10 percent of the data set ...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course