<div>
You could have used the Convert to Number error dropdown.<br />
<br />
Highlight the first cell containing an error and then Ctrl + End to select the remainder of the row. Then use the Error dropdown in the first cell and it will do all highlighted.<br />
<br />
Thanks<br />
Rob H
</div>


<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I have formatted a row of text data to numbers &nbsp;in Excel 2010. &nbsp;I can manually change all with the &quot;convert to number&quot; drop down.<br />
<br />
Is there a way to change the entire row?
</div>
</div>


Experts,

I have formatted a row of text data to numbers  in Excel 2010.  I can manually change all with the "convert to number" drop down.

Is there a way to change the entire row?

You could have used the Convert to Number error dropdown.

Highlight the first cell containing an error and then Ctrl + End to select the remainder of the row. Then use the Error dropdown in the first cell and it will do all highlighted.

Thanks
Rob H

changing a row from text to numbers in Excel 2010

Experts,

I have formatted a row of text data to numbers  in Excel 2010.  I can manually change all with the &quot;convert to number&quot; drop down.

Is there a way to change the entire row?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.