convert "1.30" to "1" and "3"

D

DarrenL

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF function with AND, having problems. 1
Concatenate when pasting. 0
Set Up Calendar To Account For Leap Years 2
userform exception error 4 textboxes 7
Naming non-contigent cells with vba 5
conditional format based on column statistics and loop over columns 1
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Sum of Variable Cells in a fixed Row 3

Top