Solved

Excel 2013:  Convert column to number accross multiple sheets

Posted on 2013-06-02
1
424 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
macro for each dropdown 15 44
Vlookup nonexact IP address match 32 36
Excel sheet question 12 23
Auto Adjust Percent rate 5 27
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

911 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

21 Experts available now in Live!

Get 1:1 Help Now