Home

Excel - Data from Text

%3CLINGO-SUB%20id%3D%22lingo-sub-652155%22%20slang%3D%22en-US%22%3EExcel%20-%20Data%20from%20Text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-652155%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20import%20from%20a%20text%20file%20-%20DATA%20FROM%20TEXT%2FCVS%2C%20for%20some%20reason%20the%20numbers%20are%20not%20as%20numbers%2C%20so%20when%20I%20enter%20%22auto%20sum%22%20at%20the%20bottom%2C%20it's%20not%20adding%20the%20numbers%20I%20need%20it%20to.%26nbsp%3B%20How%20do%20I%20fix%20the%20numbers%20without%20re-typing%20all%20of%20them%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-652155%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-652357%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Data%20from%20Text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-652357%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F350046%22%20target%3D%22_blank%22%3E%40katdiazklpa%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESelect%20your%20column%2C%20then%20go%20to%20Data%2C%20Text%20to%20Columns.%26nbsp%3B%20Hit%20Next%20three%20times%20%26amp%3B%20select%20'General'%2C%20then%20Finish.%26nbsp%3B%20Right%20click%20the%20still%20selected%20column%20%26amp%3B%20format%20the%20column%20to%20the%20Number%20format%20you%20want.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-652703%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Data%20from%20Text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-652703%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F50479%22%20target%3D%22_blank%22%3E%40Rusty%20Dane%3C%2FA%3E%26nbsp%3Bthat's%20great%20-%20I%20never%20knew%20that!!!%20thank%20you!!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-652716%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Data%20from%20Text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-652716%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F50479%22%20target%3D%22_blank%22%3E%40Rusty%20Dane%3C%2FA%3E%26nbsp%3BWhile%20waiting%20for%20a%20reply%20I%20just%20found%20that%20%22opening%22%20the%20text%20file%20in%20excel%20instead%20of%20importing%20it%20leaves%20the%20number(s)%20intact%20and%20works%20like%20the%20prior%20versions%20of%20excel%20used%20to%20work.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you!!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-655694%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Data%20from%20Text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-655694%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F350046%22%20target%3D%22_blank%22%3E%40katdiazklpa%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20to%20hear!%3C%2FP%3E%3C%2FLINGO-BODY%3E
katdiazklpa
New Contributor

When I import from a text file - DATA FROM TEXT/CVS, for some reason the numbers are not as numbers, so when I enter "auto sum" at the bottom, it's not adding the numbers I need it to.  How do I fix the numbers without re-typing all of them? 

4 Replies

@katdiazklpa 

Select your column, then go to Data, Text to Columns.  Hit Next three times & select 'General', then Finish.  Right click the still selected column & format the column to the Number format you want.

@Rusty Dane that's great - I never knew that!!! thank you!! 

@Rusty Dane While waiting for a reply I just found that "opening" the text file in excel instead of importing it leaves the number(s) intact and works like the prior versions of excel used to work.  

 

thank you!! 

@katdiazklpa 

Good to hear!

Related Conversations