[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 466
  • Last Modified:

Excel 2013: Convert column to number accross multiple sheets

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
arthurh88
Asked:
arthurh88
1 Solution
 
aikimarkCommented:
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now