Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a spreadsheet with column B having integers. I want to get the first digit of each entry in column B in the corresponding row of column C.

share|improve this question
By integers, do you mean there are some negative values? – Excellll Jul 14 '12 at 4:35

If you want them as numbers for calculation to be done


drag that down in Column C else

share|improve this answer

To build on @datatoo's answer, if your list includes negative values, you'll have to add a condition to look past any negative signs:

share|improve this answer
you COULD just take the absolute value of the cell first. abs() – lornix Jul 14 '12 at 20:10
@lornix Or that.... :P – Excellll Jul 15 '12 at 4:59

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .