Help! Removing Error Automatically...

[PP3321]

Please see below screen shot.

I have error for each data.

I would dread to click one-by-one to get rid of error...

Is there anyway to convert all to number and remove error automatically...?




Thank you...

 

[Ashhu]

You need not have to click one by one, Select everything and take action. every cell will follow same.

 

[PP3321]

Thank you...why didn't I think of that!!!

 

[Deepak]

You may also use the follow the below for large data set..

insert 1 in c5>Copy it>now select entire data cells>paste special>Multiply>ok

 

[Deepak]

Or by VBA...

    [AAA1] = 1
    [AAA1].Copy
    Range("A1:A10").PasteSpecial Paste:=xlPasteValues, Operation:=xlMultiply, _
        SkipBlanks:=False, Transpose:=False
    Application.CutCopyMode = False
    [AAA1] = ""

 

[PP3321]

So by multiplying by 1 it becomes a number...? Thank you...

 

[Deepak]

Ya! You may also use 0 to add/subtract.

 

[PP3321]

Thank you!

 

[Deepak]

This might be useful too..

https://wmfexcel.com/2016/05/14/number-stored-as-text/

 

[PP3321]

Thanks...