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
Strings representing file names with substrings of characters separated by “.” Each string has a varying number of substrings, each of which […]
Suppose I have a sequence of 32-bit (RGBa) PNG files. Is it possible to compress the RGB channel with one codec and […]
Learn about the similarities and differences of JavaScript and Python, how easy they are to learn, and which is best for you […]
Given three integers N, A, and B, the task is to find a permutation of pairwise distinct numbers from 1 to N […]