Convert cell or range value from text to number

[Nightowl_music]

im getting this error,

Invoke code: Exception has been thrown by the target of an invocation.