[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?


    Thanks


    Dani

    Hi,


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


    Hope this helps


    John

Participate now!

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

Register Yourself Login