| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Why does Custom Format not control Cell Display?
XL 2003
Have a cell which shows in the formula bar: 06/10/2005 10:10:32 AM In the worksheet (same cell but unselected) the display is: 38513.4239814815 No matter what I do with cell formating i.e. general to text to custom (BTW which is mm/dd/yyyy h:mm) the cell displays 38513.4239814815 UNLESS I select the cell - then it displays 06/10/2005 10:10:32 AM? When I de-select the cell it reverts back to 38513.4239814815 I thought that I knew better! What is the very obvious thing that I am missing? Dennis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Format Cell (Number Custom) | Excel Discussion (Misc queries) | |||
| Copying excel format from cell to cell | Excel Discussion (Misc queries) | |||
| How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
Threaded Mode
