Encounter same problem and the paste special-multiply solution works like a
magic. Bravo, Sheeloo!



"Sheeloo" wrote:

Updated file sent back.

Values in second sheet were stored as TEXT whereas in the first sheet they
were stored as NUMBERS.

You can verify this with ISNUMBER and ISTEXT functions.

To convert TEXT to NUMBERS, enter 1 anywhere, Copy it and then select the
column with text and choose PASTE SPECIAL|Multiply


"MrRJ" wrote:

Just re-sent it.

"Sheeloo" wrote:

I did not get it...

Send it to


after removing "remove."

"MrRJ" wrote:

Just sent you an email.

"Sheeloo" wrote: