select list and run this kode

Sub Convert()
For Each x In Selection
x = CDec(x)
Next
End Sub



"juanpablo" skrev:

Hi,

Sometimes, when I import databases, the numbers are not recognized and I
have to manually convert to number, using the 'autocorrect' tab by each one.
Is there a faster way to change them all at once?

Thanks

JP