Excel 2003
 

In Excel how could I get a second cell to display only the decimal
part of the number in first cell?

Foir example cell C1 has the number 1.5678 and I want the second sell
for example D1 to display only the decimal part of the number in cell
C1 i.e. 0,5678.

Thanks

Excel 2003
 

Try: =MOD(C1,1)
Micky

"grikor1" wrote:

In Excel how could I get a second cell to display only the decimal
part of the number in first cell?

Foir example cell C1 has the number 1.5678 and I want the second sell
for example D1 to display only the decimal part of the number in cell
C1 i.e. 0,5678.

Thanks
.

Excel 2003
 

On Dec 5, 12:20Â*am, מיכ×�ל (מיקי) ×�בידן <micky-a*at*tapuz.co.il wrote:
Try: =MOD(C1,1)
Micky


Thank you that worked perfectly.