On Thu, 16 Aug 2007 17:51:54 -0700, Mar Nighbor <Mar
wrote:

I am working with numbers of multiple digits in a single cell. I would like
each digit to be in its own cell within the same row, in multiple columns.
Then I am going to perform calculations on the numbers. Afterwards, I would
like to consiladate the numbers back into the same cell again.

Any ideas without using macros. I am unable to record macros on my
computer, unless you know a way around doing this without actually recording
a macro.

With the number in A2, use formula:

=MID($A2,COLUMNS($A:A),1)

and Fill Right as far as required.


If you want the numbers "right-justified", then substitute something like:

TEXT($A2,"000000000") for $A2 above
--ron