Excel Question:

Recently a number of excel data files that I download have columns that are not properly formatted. Number aren't numbers for example.

I can fix it by running text to columns, but I am curious if this may be caused by answering in excel or some other simple fix.

Thanks!
Dennis
DGWhittakerAsked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Here is a short demo....
http://www.screencast.com/t/MsV7DQ2R
0
 
JohnBusiness Consultant (Owner)Commented:
If the data was text (happens) then you get this. Select the column and reset to "general" format. Does that help?
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
The other workaround is, copy a blank cell --> select the cells with those numbers --> Paste Special --> Add --> OK.
0
 
PatHartmanCommented:
If the file is .csv rather than Excel, you cannot simply double click to open it.  You have to open an empty Excel workbook and than on the Data tab, use the import to import the .csv file.  This will allow you to specify column data types correctly.

Excel thinks it is smarter than we are but in this situation, it is most definitely NOT.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.