Rubin Shrestha
Rubin Shrestha
Blog

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

by |Published

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 ?

You may also like