Formula

[grapprise]

Hi I'm trying to remove the first two digits from the full number e.g. 52.444 needs to be .444 so that I can use this number to multiply against another number.

So 944/18 = 52.444 - I need to know what .444 x 18 =

This is what I did manually - unfortunately I have a thousand to do!

944

18

52.444

8.000

[#2]

@grapprise 

You can do this : =(A1/B1)-INT(A1/B1) where A1=944 and B1=18  to get the decimal part of the division and then multiply by the other number.

[#3]

@grapprise 

You need to remove first two digits (e.g. 152.444 => 2.444) or you need to remove integer part? If the latest, as @TheAntony suggested,  or bit shorter

=MOD(944/18,1)

[#4]

Thanks! @TheAntony