Convert A Column Of Text To Numbers REALLY quickly

This is one of my favorite Excel tips…..

Ever get a data download and one or more of your columns of data is downloaded or exported a text?. All you need to do to quickly convert the column of text to numbers is

Select A Blank Cell

Select your range of cells, in my example below it’s cells A2:A20
Hit Copy
Hit Paste Special
Click Add
Hit Ok

All of your data will now be returned as numbers!

excel-formula-crash-course-join-today-v1

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts

How To Write Excel Macros For Beginners

You don't need to be a programmer to write Excel macros. With just a little knowledge of how macros work, you can start creating your macros to automate tasks in Excel. You'll need to use the Visual...

Formula Friday - Resize The Excel Formula Bar.

Hello Excellers, welcome to another #formulafriday blog post in my #ExcelTips series. Excel has a wide range of features, and the formula bar is one of the most important of...

Share

Popular Pages
Home