View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Derek510 Derek510 is offline
external usenet poster
 
Posts: 1
Default How to split numeric result of a formula in a cell into 2 cells?

I have a formula for a cell, where the result will be numerical (123.5678). I
want to be able to split the results from that cell into 2 cells so that 123
is in one cell and .5678 is in the cell next to it so that separate formulas
can be made using the two separate data. I am using Excel 2003.