Hi,

If the 10-digit numbers are in A2:A101, enter the following formula in B2
and enter. Autofill the formula down to B101.

=LEFT(A2,6)

If you don't want the original numbers any more, select and copy B2:B101,
"Edit" -- "Paste Special" -- "Values" -- "OK". Then delete Column A.

Regards,
B. R. Ramachandran

"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 that possible?