ExcelBanter - convert "1.30" to "1" and "3"

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - convert "1.30" to "1" and "3" (https://www.excelbanter.com/excel-programming/430324-convert-1-30-1-3-a.html)

DarrenL

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

Mike H

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

Hi,

Try these

=INT(A1)

and for the decimal

=MOD(A1,1)

Mike

"DarrenL" wrote:

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

Jacob Skaria

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

=INT(a1)
=MOD(a1,1)*10

If this post helps click Yes
---------------
Jacob Skaria

"DarrenL" wrote:

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

All times are GMT +1. The time now is 02:26 PM.