If you try this

=RIGHT(a1,3)&LEFT(a1,3), and drag for entire range
it will return your number as a text format only, so you cant work with it

Then select the new data, copy and paste Special into the same place, then
click on the little yellow warning marker and convert to number


--
RWS


"Roger Govier" wrote:

Hi Brian

I may have misunderstood your request. My solution was for changing the
order of numbers in a cell.
If your data is in individual cells, going down column A, and you want
them reveres in column B, then try entering in B1
=INDEX($A$1:$A$100,COUNT(A$1:$A$100)+1-ROW(1:1))
and copy down column B as required

--
Regards

Roger Govier


"Roger Govier" wrote in message
...
Hi Brian

With the number to be reversed in cell A1, try

=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),
(10^(ROW(INDIRECT("1:"&LEN(A1)))))/10)

--
Regards

Roger Govier


"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.