View Single Post
  #5   Report Post  
Brian
 
Posts: n/a
Default

Thanks Art.

Works like a charm.

Although the first time I typed it into the cell it just sat there like it
was text. But then I retyped it and all is well.


"Art" wrote:

Assume that your 6 digit number is in A1. You can get what you want using
the following three formulas:

=VALUE(LEFT(A1,2))
=VALUE(MID(A1,3,2))
=VALUE(RIGHT(A1,2))

Art

"Brian" wrote:

I have a column which contains 6 digit numbers (i.e. 123456).

I want to convert it into 3 columns of 2 digit numbers (i.e. Column A
=12,Column B=34,Column C=56).

Anyone know how?

Thank you.