Good day my friends,
I have a rather interesting problem I have not been able to sort. I have a line of code that extracts the last two digits of a certain cell and places them in the cell next to it. However, if the last two digits are Zeros it only returns the first whole number in the cell.
This is what I have...
If my cells value is 6.00 it returns 0.60 now matter how I change the format or the VBA code.
Note...
In order for everything else to work... the "0." in my code must remain as it is part of a Vlookup.
Thanks for any advice.
Cheers