| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Decimal Conversion
How can I get 12005400.150 in one cell to calculate 150 into a different cell.
|
|
#2
|
|||
|
|||
|
=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. |
|
#3
|
|||
|
|||
|
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. |
|
#4
|
|||
|
|||
|
Note that, on my machine at least (XL04), that results in
150.0000004 In article , Myrna Larson wrote: =MOD(A1,1)*1000 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
| Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. | New Users to Excel | |||
| ROUND DATA TO 2 DECIMAL PLACES | New Users to Excel | |||
| decimal point override does not work | Excel Discussion (Misc queries) | |||
| How do I indent a decimal aligned column from the margin? | Excel Discussion (Misc queries) | |||
Linear Mode
