| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
14 decimals at the import from excel to word
Hello,
I use Office 2007; i made a combination between an Excel file and a Word one. My problem: After i realised this joining, in Word, the numbers appear with 14 decimals but i want to have only 2 decimals! In Excel file, ( the source ), these numbers are ok, with 2 decimals. I guess this problem comes from the Word file and i must modify somewhere. Does somebody have any ideea? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
14 decimals at the import from excel to word
The "problem" is in the Excel file, you probably formatting set to 2
decimals. You can either use ROUND in a formula like =ROUND(A1,2) or toolsoptionscalculation and select precision as displayed -- Regards, Peo Sjoblom "Adrian" wrote in message ... Hello, I use Office 2007; i made a combination between an Excel file and a Word one. My problem: After i realised this joining, in Word, the numbers appear with 14 decimals but i want to have only 2 decimals! In Excel file, ( the source ), these numbers are ok, with 2 decimals. I guess this problem comes from the Word file and i must modify somewhere. Does somebody have any ideea? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import Word.doc into Excel | Excel Discussion (Misc queries) | |||
| How do I Import Data From Excel to Word | Excel Discussion (Misc queries) | |||
| Hom do I import a word doc. into excel? | Excel Discussion (Misc queries) | |||
| Merging Excel data to word, keeps including all decimals on number | Excel Discussion (Misc queries) | |||
| How do I import a WORD file into EXCEL? | Excel Discussion (Misc queries) | |||
Linear Mode
