replacing dynamic currency amounts with a character
Hello all,
I have a request from a Business Unit and I am baffled.
We will be getting an excel spreadsheet each day and the amounts in a
particular column will change as will the number of rows.
i need to replace the last character in the amount with a particular
alpha character.
example:
20.50 = 20.5}
65.01 = 65.0J
it only changes the last penny.
if anyone could help on this, i would greatly appreciate it. i am not
savvy in this.
thanks,
tony
|