Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

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
0
wcody
Asked:
wcody
1 Solution
 
jppintoCommented:
=LEFT(C2,1)
0
 
Saqib Husain, SyedEngineerCommented:
=left(c1,1)

or

=value(left(c1,1))
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now