Decimal Conversion

[Guest]

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

 

[Myrna Larson]

=MOD(A1,1)*1000

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

cell.

 

[JE McGimpsey]

One way:

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


another:

= A1 * 0.000012494377374

or even:

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

 

[JE McGimpsey]

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

150.0000004