Solved

Excel 2013:  Convert column to number accross multiple sheets

Posted on 2013-06-02
1
413 Views
Last Modified: 2013-06-02
there are 35 different sheets in my workbook. Column B are all numbers, but many of them are "numbers stored as text".  How do I convert all Column B on all sheets to be a number without clicking on every worksheet tab?
0
Comment
Question by:arthurh88
1 Comment
 
LVL 45

Accepted Solution

by:
aikimark earned 500 total points
ID: 39215306
You can select all the worksheets by selecting the first sheet (usually the default worksheet selection) and then hold the shift key down when clicking on the last worksheet.  Any work you do, such as formatting will affect the same row/column in all the selected worksheets.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now