Custom numeric formats

  • Anybody have a suggestion as to how I can format a cell so that Excel will automatically take the last digit, divide by eight and express as a decimal? For example, 5667 would appear as 566.875.
    (566 7/8).
    I can easily format the cell to recognize 566 7/8 and change it into 566.875, but the data I am entering comes in the form 5667. Thanks for any help...

Participate now!

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