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

import large numbers from csv file

1

I import large numbers via a csv file and recently I noticed that the numbers have become larger and when I import them into Excel, sometimes the number gets truncated and there are zeros at the end of it and it also appears in scientific notation.

How can I make Excel keep the entire number instead of rounding or truncating it and also not show in scientific notation by default?

Ex.

123456789123456789123456789

becomes

1.23456789123456E+26

And

123456789123456789

becomes

123456789123456000

Thanks,

Sam

Answer
Discuss

Answers

1
Selected Answer

Hi there Sam!

The easiest way to keep the numbers when you import large ones from a csv file is to import that column of data as Text.

Go to the Data tab > click the From Text button > select the desried csv file > follow the import wizard and don't click the Finish button until you get to step 3.

On step 3, look to the bottom area of the window and click the column of data that has the numbers and then click the optionĀ Text at the top of the window.

When you click Finish, the numbers will be imported without being truncated or rounded.

Discuss

Discussion

Ahhh thank you so much it works perfectly!!!!
sammyB (rep: 4) Apr 11, '17 at 9:49 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login