Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display Part of the cell value
Hi Everybody,
From a calculation part(formula in a cell) I'm getting a value wuth three decimal places.(ex: 27.874) Now I wanted this result should be displayed in two cells as value befor e the decimal point and in second cell after the decimal point. Ex: In Cell C1 I have 27.874 then D1 = 27 E1 = 0.874 Is it possible, If so pl tell me. Thanks and Regards Ramana |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display Part of the cell value
in cell D1 use
=TRUNC(C1) in E1 use =C1-D1 "ramana" wrote: Hi Everybody, From a calculation part(formula in a cell) I'm getting a value wuth three decimal places.(ex: 27.874) Now I wanted this result should be displayed in two cells as value befor e the decimal point and in second cell after the decimal point. Ex: In Cell C1 I have 27.874 then D1 = 27 E1 = 0.874 Is it possible, If so pl tell me. Thanks and Regards Ramana |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display Part of the cell value
D1: =INT(C1)
E1: =MOD(C1,1) or =C1-D1 -- HTH RP (remove nothere from the email address if mailing direct) "ramana" wrote in message ups.com... Hi Everybody, From a calculation part(formula in a cell) I'm getting a value wuth three decimal places.(ex: 27.874) Now I wanted this result should be displayed in two cells as value befor e the decimal point and in second cell after the decimal point. Ex: In Cell C1 I have 27.874 then D1 = 27 E1 = 0.874 Is it possible, If so pl tell me. Thanks and Regards Ramana |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display Part of the cell value
Hi,
Thank you verymuch for your replies. Thanks and Regards Ramana |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display Part of the cell value
On Wed, 16 Nov 2005 12:16:27 -0000, "Bob Phillips"
wrote: D1: =INT(C1) E1: =MOD(C1,1) or =C1-D1 Only for positive numbers, though. --ron |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display Part of the cell value
On 16 Nov 2005 03:45:19 -0800, "ramana" wrote:
Hi Everybody, From a calculation part(formula in a cell) I'm getting a value wuth three decimal places.(ex: 27.874) Now I wanted this result should be displayed in two cells as value befor e the decimal point and in second cell after the decimal point. Ex: In Cell C1 I have 27.874 then D1 = 27 E1 = 0.874 Is it possible, If so pl tell me. Thanks and Regards Ramana How do you want to display the fractional portion if the number is negative? With the negative sign in front of both, then Duke's formulas work. If you want the fractional part to be positive, then his second formula should be: =ABS(C1-D1) --ron |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display Part of the cell value
Thanks Ron for the formula
Rgds Ramana |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display text 1024 characters in a cell | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
Need Workaround for Cell Display Limitation in Excel 2000 | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel |