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?
arthurh88Asked:
Who is Participating?
 
aikimarkConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.