Need to split a 6 digit number

[avadhutd2]

Hi,

I need to split a 6 digit number into two - first digits & remaining 5 digits.

As a example - Consider Cell A1 had value 123456 & we will have to split it into two parts as "1" & "23456".

Can I store these separated values some where and use it?
I need these to be split as I need to compare these values with some other.

Thanks in advance...

[JKwan]

in cell B1, enter "=mid(A1,1,1)", in cell C1 enter, "=mid(A1,2,5)" then do a fill down

[Bob Phillips]

B1: =LEFT(A1,1)
C1: =MID(A1,2,99)

[mikerickson]

These give non text results
B1: =(A1-C1)/100000
C1: =MOD(A1,100000)