Another excel question. I'm using Excel 2010.

If for example I have a value in cell A1, lets say 2.59

What I want to do is multiply that cell by 1.333 but in the **same** cell

I don't want to have to put a formula in B1 such as =(A1*1.333), because I already have a value in B1 and I don't want to have to insert a new column.

if I highlight cell A1 and put the formula =(A1*1.333) into it the value becomes 0.00

Can what I'm asking be done? or would I need to create a macro?

Any help would be appreciated.

Thanks