View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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.