| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003
In Excel how could I get a second cell to display only the decimal
part of the number in first cell? Foir example cell C1 has the number 1.5678 and I want the second sell for example D1 to display only the decimal part of the number in cell C1 i.e. 0,5678. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003
Try: =MOD(C1,1)
Micky "grikor1" wrote: In Excel how could I get a second cell to display only the decimal part of the number in first cell? Foir example cell C1 has the number 1.5678 and I want the second sell for example D1 to display only the decimal part of the number in cell C1 i.e. 0,5678. Thanks . |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003
On Dec 5, 12:20*am, מיכאל (מיקי) אבידן <micky-a*at*tapuz.co.il wrote:
Try: =MOD(C1,1) Micky Thank you that worked perfectly. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| importing/linking data from an Access 2003 Query to an Excel 2003 | Excel Discussion (Misc queries) | |||
| Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
| import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
| Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
| Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) | |||
Linear Mode
