I have a worksheet from a customer which include negative numbers however the negative numbers have the negative sign at the back.
Thesse are three columns as an example..
Please Login or Register to view this content.
I wish to develop a macro to find the cells with this negative number in the worksheet. So I need to find cells with "-" sign at the end , for these cells I need to remove the "-", and then multiply the number to get into correct negative format.
Like this..
Please Login or Register to view this content.
Bookmarks