How to return first 3 digits of a number?

C

Curalice

Column A has 10 digit numbers, I want Column B to have only the first
three digits of each number.
Please help.
Thanks!
 
S

Sandy Mann

Try:

=LEFT(A4,3)

which return the three *numbers* as text

if you need the three numbers to still be numbers use:

=--LEFT(A4,3)

--
HTH

Sandy
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumif and wildcards 4
Validation of UK VAT Number 20
Looking for a Function? similar to LEFT 4
Lookup references 3
Compare List Summary of Results 3
How do I calculate age using a 12 digit social security number in MS Excel? 0
which formula? Match? IF? 4
Adding a zero to the front of numbers 5

Top