Zend certified PHP/Magento developer

Convert 1M to 1000000 in the same cell – MS Excel

I use =SUBSTITUTE(UPPER(A1),"M","e6")+0 by @Mobus to convert 1M to 1000000

But the new number is outputted in another cell, how do I make it stay in the original cell ?