| 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 |
| 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 | |||
Threaded Mode
