View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DarrenL DarrenL is offline
external usenet poster
 
Posts: 13
Default convert "1.30" to "1" and "3"


Hi. I am faced with a dilemma. Cell (a1)= "1" and Cell (a2)= ".30" Cell
(a3)= sum(a1:a2) or "1.30"
The QUESTION!!!!!
How would I reverse that........
User enters "1.30" in Cell (a1) and I need two Cells to break that out into
"1" and "3" respectively. Any thoughts?

Thanks
Darren