wcody
asked on
Display a cells first digit
In the attached sheet i would like to have a formula that will display the first digit of the numberr sequence in the adjacent cell. example cell c1 has the following: 1811002
so i would like the number in cell d1 to be 1
c2 has 3858093 so I would like d2 to have 3.
expert.xlsx
so i would like the number in cell d1 to be 1
c2 has 3858093 so I would like d2 to have 3.
expert.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
or
=value(left(c1,1))