How do I shorten 10-digit # so only 6 digits show up?

I have a list of 10-digit numbers, but I want to apply a formula/function or
format the cells so that only the first 6 digits show up. Is this possible?

Something like:
=INT(a1/10000)


swingkittenva wrote:
>
> I have a list of 10-digit numbers, but I want to apply a formula/function or
> format the cells so that only the first 6 digits show up. Is this possible?

--

Dave Peterson

=left(A1,6)

"swingkittenva" wrote:

> I have a list of 10-digit numbers, but I want to apply a formula/function or
> format the cells so that only the first 6 digits show up. Is this possible?

=left(A1,6)

"swingkittenva" wrote:

> I have a list of 10-digit numbers, but I want to apply a formula/function or
> format the cells so that only the first 6 digits show up. Is this possible?

=left(A1,6)


swingkittenva wrote:
> I have a list of 10-digit numbers, but I want to apply a formula/function or
> format the cells so that only the first 6 digits show up. Is this possible?