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!