Thread: Decimal Places
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
college student ATL college student ATL is offline
external usenet poster
 
Posts: 1
Default Decimal Places

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?