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

S

swingkittenva

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?
 
D

Dave Peterson

Something like:
=INT(a1/10000)

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?
Click to expand...
 
Top