View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ramana
 
Posts: n/a
Default Display Part of the cell value

Hi Everybody,

From a calculation part(formula in a cell) I'm getting a value
wuth three decimal places.(ex: 27.874) Now I wanted this result should
be displayed in two cells as value befor e the decimal point and in
second cell after the decimal point.

Ex: In Cell C1 I have 27.874
then D1 = 27
E1 = 0.874

Is it possible, If so pl tell me.

Thanks and Regards

Ramana