Don't. Use another cell with a formula. I can't think of any good reason to do this what Excel wasn't designed to do.
Of course it can be done using VBA, but why should you?

--
Kind regards,

Niek Otten

"KW" wrote in message ...
I'm working on a spreadsheet, and I want a cell to automatically calculate
the number I put in by a predetermined number. So, I put 2 in the cell, I
want it to multiply by 27 and put the total in the cell.