I copied an excel file of nursery plant prices.

Then I tried using the PRODUCT formula on the copied file.

But the formula produced the #VALUE! no matter if the copied price format was TEXT or NUMBER or GENERAL OR CURRENCY. And if the formula is =PRODUCT(C3,1.2) no matter what price was in space C3 - the answer comes up as 1.2

If I empty the space C3 and then retype the price in that space - the formula works properly.

But I have too many prices to retype them all.