# adding decimals into whole number

Hi,

I am using excel 2003
how can you add a 2 decimal number into the main number?

eg. 10.15 into 10+15?
###### Who is Participating?

Commented:
=INT(A1)+SUBSTITUTE(TEXT(MOD(A1,1),"general"),".","")
should work I think, but is getting silly. ;)
0

Commented:
So if A1 is 10.15, you want to get 10+15=25 as the answer?

=ROUND(A1,0)+INT((A1-ROUND(A1,0))*100)
0

Commented:
Or

=ROUND(A1,0)+INT(MOD(A1*100,100))
0

ConsultantCommented:
Hi,

If you have 10.15 in A1 then use this:

=INT(A1)+((A1-(INT(A1)))*100)

Alan.
0

Commented:
If you have 10.15 in A2 try this formula in B2

=INT(A2)+MOD(A2,1)*100

regards, barry
0

ConsultantCommented:
That's the best one Barry - good thinking!

Alan.
0

Commented:
For postering, because I messed up using ROUND instead of INT (even though it gets used in the 2nd part...)

if A1 is 10.15, and you want to get 10+15=25 as the answer..

=INT(A1)+INT(MOD(A1,1)*100)

10.159999 will also end up as 25
0

Commented:
Sorry, I was testing Barry's formula and got mixed up, I meant to correct my 2nd one

=INT(A1)+INT(MOD(A1*100,100))
0

Author Commented:
CAn there be a formula to do it when it is 1 decimal place?

Sorry that if i forgot to mention there are instances where it may be like

10.1 or 0.1
0

Commented:
So if it is 10.1 -> 11? or 20?
And can it be 10.1456 -> 10 + 1456 = 1466?
0

Commented:
If your number is in A1

=IF(A1=INT(A1),A1,INT(A1)+MID(A1,FIND(".",A1&".")+1,100))
0

ConsultantCommented:
But perhaps 10.1456 = 10+14.56 = 24.56 ?

There may be a secret algorithm ;->

Alan.
0

Commented:
Variation on a theme:
=INT(A1)+SUBSTITUTE(MOD(A1,1),"0.","")
0

Commented:
PS the above assumes your numbers are always positive.
0

Commented:
Rory, I get

10.1      => 1E+15
10.62 => 6.2E+14
0

Commented:
Ah, yes. Stupid bloody floating points. :)
0

Commented:
Or:
=INT(A1)+SUBSTITUTE(A1&".0",INT(A1)&".","")
0

Commented:
That last one is very Barry-like.  Real good
0

Commented:
csharp_learner,
As you got multiple working solutions - and before my post too - I think a points split would be fairer here.
Regards,
Rory
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.