1.23 return to 0.23

[swwong]

Hello

I input 1.23 in A1
but I want B1 to return to 0.23

How can I do that?

Thanks

 

[DJH]

in B1 =A1-Int(A1)

 

[Ron Rosenfeld]

Hello

I input 1.23 in A1
but I want B1 to return to 0.23

How can I do that?

Thanks!

B1: =MOD(A1,1)


--ron

 

[Ragdyer]

OR,

=MOD(A1,1)

 

[Bruce Sinclair]

Hello

I input 1.23 in A1
but I want B1 to return to 0.23

How can I do that?

[/QUOTE]

in B1 =A1-Int(A1)

isn't there a FRAC function to get just the fractional part ? (1.23 might be
a bad example of x.23 ).


Bruce


-------------------------------------
The power of accurate observation is commonly called cynicism by those who have not got it.
- George Bernard Shaw
Cynic, n: a blackguard whose faulty vision sees things as they are, not as they ought to be.
- Ambrose Bierce

Caution ===== followups may have been changed to relevant groups
(if there were any)

 

[Barb Reinhardt]

How about the following in B1
=MOD(A1,1)