Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Posts
    14
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Word 2007 - Whole numbers displayed

    I have imported figures to two decimal places from MS Excel 2007 into MS Word 2007. The figures in MS Word 2007 are now rounded to whole figures. Is there anything that needs to be changed in MS Word 2007 so that the figures appear to two decimal places please?

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    Are you linking/embedding the XLS data, or copying/pasting it (e.g., it turns into a native Word table)? Either way, the formatting you applied to the cells in Excel should carry over, but perhaps it is being overridden somehow.

  3. #3
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts
    Welcome to the Lounge!

    There are a few different ways to get figures from Excel into Word, so can you describe in more details the steps you're currently using? - that will help home in on the problem.

    Gary

  4. #4
    New Lounger
    Join Date
    Jan 2001
    Posts
    14
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I am copying/pasting from MS Excel 2007into MS Word 2007 and it turns into a Word table. I agree that the formatting should be applied and it should be carried over but, as has been suggested, perhaps it is being over written somehow - in Word?

  5. #5
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts
    Hm, that is hard to reproduce. There are some settings under Word Options > Advanced > Cut, copy and paste - but none of them appear to cause numbers to truncate when pasted into Word.
    By the way, are the numbers simply being truncated, or are they truly being rounded?

    Gary

  6. #6
    New Lounger
    Join Date
    Jan 2001
    Posts
    14
    Thanks
    3
    Thanked 0 Times in 0 Posts
    The numbers are being rounded which is rather strange. I am putting it down to one of those "quirks" that one gets from time to time with software!
    Many thanks for all who have responded - much appreciated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •