Reply To: Bluebeam use with Excel and Fabsuite

  • Carl Wegman

    Member
    August 28, 2023 at 3:44 pm
    Points: 817
    Rank: UC2 Brainery White Belt III UC2 Brainery White Belt III

    Here is an excel formula that assumes your decimal feet measurement is in cell A2.

    This is from the Microsoft website.

    =TRIM(INT(MROUND(A2*12, 0.0625)/12) & ” ft ” & TEXT(MOD(MROUND(A2*12, 0.0625),12),” # ?/?? \i\n”))