I use the formula =ArrayFormula(left($A2:$C2,1)) to get the first digit of double digit numbers.

if data is 12, the result is 1.

if data is 2, the result is 2.
as expected.

I would like the formula to give 0 when it is a single digit number instead of 2 in the above example. so the formula should treat the data as 02 in this case.

I’d like to do that without changing the data itself.
Is there a way to do this? thanks.

>Solution :

Use

=ArrayFormula(IF(LEN($A2:$C2)=1,0,LEFT($A2:$C2)))