Removing digits

[GFH]

Hi all,

I have a set of number sI have to add up after the total is summed I
would like to remove or display (prefer remove) thsome of the leading
digits and have remaing only one digit to the left of the decimal

IE

2.3+4.7+3.9+6.7=17.6 I then want to remove the "1" and any other
digit left of the "1" and display only the 7 and the 6 resulting in
"7.6" being returned to the cell.

Can that be done?

many thanks

Gord

 

[Dave R.]

=MID(A1,FIND(".",A1)-1,1)+MOD(A1,1)

 

[Dana DeLouis]

Maybe as text:
=TEXT(MOD(A1,10),"0.0")

or as a number:
= --TEXT(MOD(A1,10),"0.0")

HTH
Dana DeLouis

 

[Ron Rosenfeld]

Hi all,

I have a set of number sI have to add up after the total is summed I
would like to remove or display (prefer remove) thsome of the leading
digits and have remaing only one digit to the left of the decimal

IE

2.3+4.7+3.9+6.7=17.6 I then want to remove the "1" and any other
digit left of the "1" and display only the 7 and the 6 resulting in
"7.6" being returned to the cell.

Can that be done?

many thanks

Gord

=INT(MOD(SUM(rng),10)*10)/10


--ron