+ Reply to Thread
Results 1 to 3 of 3

Round up all numerical figures in word doc (currently all 2 decimal places)

  1. #1
    Registered User
    Join Date
    05-26-2014
    Posts
    16

    Round up all numerical figures in word doc (currently all 2 decimal places)

    Hi all,

    There is a software that generates raw data in word full of tables with figures to 2 decimal places. I'd like to macro it so that it converts all figures with decimal places to whole numbers (rounded up or down as per standard).

    I ran into some other macro examples but when i pasted them in they said "Cannot access individual rows in this collections because the table has vertically merged cells".

    If anyone knows an easy macro i can use to do this, i would be so appreciative!

    Attached is a copy of a word doc with the tables i would be using.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-26-2014
    Posts
    16

    Re: Round up all numerical figures in word doc (currently all 2 decimal places)

    Just checking in anyone got a solution? Thanks in advance.

  3. #3
    Registered User
    Join Date
    05-26-2014
    Posts
    16

    Re: Round up all numerical figures in word doc (currently all 2 decimal places)

    Thought i'd give this one last bump as i'm suprised no one has anything. Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Round variable to 4 decimal places
    By achidsey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2014, 02:52 PM
  2. [SOLVED] Round 2 decimal places
    By Ventoux in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2013, 02:17 PM
  3. [SOLVED] Round numbers to decimal places
    By bigband1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-01-2013, 11:34 AM
  4. [SOLVED] Function to round up if more than 2 decimal places
    By lauralizzy in forum Excel General
    Replies: 1
    Last Post: 06-28-2012, 09:30 AM
  5. [SOLVED] Round Single Variable To 2 Decimal Places
    By nevi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2012, 02:33 PM
  6. round down to 2 decimal places as a general rule
    By janper in forum Excel General
    Replies: 5
    Last Post: 06-13-2009, 12:01 PM
  7. Round to two decimal places
    By golfnutte in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-08-2007, 05:48 PM
  8. [SOLVED] ROUND DATA TO 2 DECIMAL PLACES
    By roy in sunbury in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-12-2005, 12:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1