VBA - removing last digits in excel , beginner

[Metroid]

Hello,

I have never used VBA before, so please go easy on me.

I would like to go through list of asset numbers and if any number ends with one or more zeroes, I would like them removed.

I have drafted something like:

Please Login or Register  to view this content.

Please check my syntax and logical process for any errors.

[TMS]

Almost.

Select the cells before running the macro.

Please Login or Register  to view this content.

Regards