Decimal Places

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

college student ATL - 12 Sep 2007 23:56 GMT

If I have a number in a cell (e.g., 3.456), how can I return just the decimal
part of it (0.456) to another cell? Conversely, if I have Cell 1 = 50 and
Cell 2 = 55, how can I join them in a new cell to make the number 50.55?

Reply to this Message

Peo Sjoblom - 12 Sep 2007 23:58 GMT

=MOD(A1,1)

=A1+A2/100

Signature

Regards,

Peo Sjoblom

> If I have a number in a cell (e.g., 3.456), how can I return just the
> decimal
> part of it (0.456) to another cell? Conversely, if I have Cell 1 = 50 and
> Cell 2 = 55, how can I join them in a new cell to make the number 50.55?

Reply to this Message

Teethless mama - 13 Sep 2007 00:22 GMT

Your second formula fail, if

A1= 50
A2= 578

=A1+A2/100
Your formula returns 55.78, should be 50.578

Teethless mama formula return 50.578
=A1+A2/(10^LEN(A2))

> =MOD(A1,1)
>
[quoted text clipped - 4 lines]
> > part of it (0.456) to another cell? Conversely, if I have Cell 1 = 50 and
> > Cell 2 = 55, how can I join them in a new cell to make the number 50.55?

Reply to this Message

JE McGimpsey - 13 Sep 2007 00:30 GMT

Slightly more efficient:

=--(A1&"."&A2)

> Your second formula fail, if
>
[quoted text clipped - 15 lines]
> > > part of it (0.456) to another cell? Conversely, if I have Cell 1 = 50 and
> > > Cell 2 = 55, how can I join them in a new cell to make the number 50.55?

Reply to this Message

Rick Rothstein (MVP - VB) - 13 Sep 2007 02:12 GMT

> Teethless mama formula return 50.578
> =A1+A2/(10^LEN(A2))

Two parentheses more than needed...

=A1+A2/10^LEN(A2)

Rick

Reply to this Message