One way:

=INT(MOD(A1,1)*1000)


another:

= A1 * 0.000012494377374

or even:

=--MID(TEXT(A1,"0.000"),FIND(".",A1)+1,255)




In article ,
"Brian" wrote:

How can I get 12005400.150 in one cell to calculate 150 into a different cell.