Thread
:
Decimal Places
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
external usenet poster
Posts: 3,268
Decimal Places
=MOD(A1,1)
=A1+A2/100
--
Regards,
Peo Sjoblom
"college student ATL" <college student
wrote
in message ...
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 With Quote
Peo Sjoblom
View Public Profile
Find all posts by Peo Sjoblom