Forum Discussion
How to extract digits and make it be able to show 0 in the first digits?
Hi folks, Maybe the quesiton in one sentence is not clear. I am trying to extract 4 digits from a list of cells, but because some of the digits have 0 infront of them. So in the new column when I am...
Gabriella,
if the value in cell A3 is a number then it would show as 987. But if you apply a number format like 0000 then it shows as 0987.
=RIGHT(TEXT(A3,"0000"),4)