View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tevuna Tevuna is offline
external usenet poster
 
Posts: 136
Default How do you truncate 2.22 to just 0.22?

Every simple problem has a multitude of solutions. Here are two
=A1-ROUND(A1,0)
=MOD(A1,ROUND(A1,0))

"Crackles McFarly" wrote:

Say I have a list of cells with numbers, some even some odd and some
with trailing decimals like so.
2
2.33
2.833
2.99
3
3.5
4
4.22

How can I get rid of the WHOLE number ? I need to manipulate the part
that is not the whole number.
thnx