Multiply column in excel which are in format text

Hi @Tapiwa
Refer to this post. I hope this help you.