[Solved] VBA : Bookmarks and number values of formulas

  • Hi everyone

    I have some code which takes a range in exceland puts the data in the range after a bookmark in word. However I am having one problem with ranges that contain formulas in it. Although the cell is set to 2 decimal places, when the data is imported into word the number will have 12 decimal places!

    I dont know why this happens, but does anyone know how I can overcome this?



  • Hi,

    If the formula you are using is
    =ROUND(SUM(R[-5]C:R[-1]C) ,2)
    This will round it off to 2 decimal places

    Hope this helps


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!