Here's two of many options, assuming they are indeed 6 digit numbers.

=MOD(A1,1000)*1000+INT(A1/1000)
=--(RIGHT(A2,3) & LEFT(A2,3))

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"brian" wrote in message
...
i'm trying to figure out if there is any way to switch a column of 6 digit
numbers so that the first 3 numbers are the last 3 and vise versa.
example..
111222=222111, or 198321=321198. any help would be welcomed. thanks for
your time.