How can I get 12005400.150 in one cell to calculate 150 into a different cell.
B Brian Feb 21, 2005 #1 How can I get 12005400.150 in one cell to calculate 150 into a different cell.
M Myrna Larson Feb 21, 2005 #2 =MOD(A1,1)*1000 How can I get 12005400.150 in one cell to calculate 150 into a different Click to expand... cell.
=MOD(A1,1)*1000 How can I get 12005400.150 in one cell to calculate 150 into a different Click to expand... cell.
J JE McGimpsey Feb 21, 2005 #3 One way: =INT(MOD(A1,1)*1000) another: = A1 * 0.000012494377374 or even: =--MID(TEXT(A1,"0.000"),FIND(".",A1)+1,255)
One way: =INT(MOD(A1,1)*1000) another: = A1 * 0.000012494377374 or even: =--MID(TEXT(A1,"0.000"),FIND(".",A1)+1,255)
