| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=left of decimal
In column A I have a lift of numbers that are upto 10 decimal places. I
would like to populate column B with what is to the left of the decimal point in column A in the same row. Can this be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=left of decimal
Use the INT function. In cell B1 enter:
=INT(A1) Copy down as needed. HTH, Elkar "The Rook" wrote: In column A I have a lift of numbers that are upto 10 decimal places. I would like to populate column B with what is to the left of the decimal point in column A in the same row. Can this be done? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=left of decimal
=int(a1)
will bring back the whole number portion of what's in A1. Then copy that formula down as far as you need it. If you wanted the decimal portion, you could use: =a1-int(a1) or =mod(a1,1) The Rook wrote: In column A I have a lift of numbers that are upto 10 decimal places. I would like to populate column B with what is to the left of the decimal point in column A in the same row. Can this be done? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| I need to enter 10 chars to left of decimal and 5 to right. | Excel Worksheet Functions | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| How to change the right-to-left worksheet to left-to-right workshe | Excel Discussion (Misc queries) | |||
| Why does the decimal move to the left on all numbers? | Excel Discussion (Misc queries) | |||
![The Rook[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
