Forum Discussion

Gabriella Yin's avatar
Gabriella Yin
Copper Contributor
Aug 10, 2017

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 only use the "RIGHT(A3, 4)"formula the 0 is not showing up if the digits were: 0987. It shows as 987 in the new cell. I would like to know how to fix this problem. 

 

Thank you very much!!

 

Formulas & Functions
Need Help

1 Reply

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Aug 11, 2017

    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)

Resources