help:Error message convert to number

[emadtira]

i have error message when i make copy and paste special then values in cells contains text formula before copy

question: i want to choose convert to number from options with error but not for one cell to all of cells that contain error in one step.

thanx

 

[Ruddles]

You haven't showed us the error message, the code which causes it, the values of any of the variables used in your procedure or what your data looks like.

I'm afraid we're going to struggle to give you any useful assistance on that basis.

 

[leibale]

Selet the area with the error and then change it to number