| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying 5000
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying worksheet name in cell | Excel Discussion (Misc queries) | |||
| displaying selected items from a yearplanner in a timesheet | Excel Discussion (Misc queries) | |||
| Displaying Product value only when it is greater than $0.00 | Excel Discussion (Misc queries) | |||
| Fonts not displaying correctly | Excel Discussion (Misc queries) | |||
| Displaying a blank cell | Excel Discussion (Misc queries) | |||
Threaded Mode
