I have a student that wants to display 5 in a cell when the raw value is
5000. I tried the scientific format but do not want the E+3 to show. Any
ideas? Truncate? The thousands number will be changing.

Thanks in advance for any assistance offered.