View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MarNy MarNy is offline
external usenet poster
 
Posts: 1
Default Seperate digits of a number by columns and back again

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
--
Have a GREAT day!

Mar