Decimal Conversion
 

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

=MOD(A1,1)*1000


On Mon, 21 Feb 2005 12:15:06 -0800, "Brian"
wrote:

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

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.

Note that, on my machine at least (XL04), that results in

150.0000004

In article ,
Myrna Larson wrote:

=MOD(A1,1)*1000