How can I remove multiple 'errors' in Excel error checking, at the same time???

  • Thread starter Thread starter bertbarndoor
  • Start date Start date
B

bertbarndoor

So, I have a worksheet with data pasted in from a Database. I have, for
instance, a column that is all numbers stored as text. I'd like to
convert all the cells at the same time. OR, I would like excel to
ignore the error for all of them.

Forget telling me to format the column as a number. It doesn't work.
Thanks,

Rob
 
So, I have a worksheet with data pasted in from a Database. I have, for
instance, a column that is all numbers stored as text. I'd like to
convert all the cells at the same time. OR, I would like excel to
ignore the error for all of them.

Forget telling me to format the column as a number. It doesn't work.
Thanks,

Rob
Click to expand...

Rob - Select a cell containing the error then hit Ctrl+A to select all
cells in the workbook. Now when you choose the option to ignore error
or convert to number it applies to all cells...

Lori
 
Lori said:
(e-mail address removed) wrote:

> So, I have a worksheet with data pasted in from a Database. I have, for
> instance, a column that is all numbers stored as text. I'd like to
> convert all the cells at the same time. OR, I would like excel to
> ignore the error for all of them.
>
> Forget telling me to format the column as a number. It doesn't work.
> Thanks,
>
> Rob

Rob - Select a cell containing the error then hit Ctrl+A to select all
cells in the workbook. Now when you choose the option to ignore error
or convert to number it applies to all cells...

Lori
Click to expand...

That was brilliant just that it doesn't apply to the Total or Grand Total
 
Back
Top