| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
before entering any data, format the cell as text. Then, for example, if you
enter 11/05, that's what will appear in both the cell and the function bar. -- Gary's Student "Beenthere12" wrote: How do i get excel to show mm/yy in Funcation bar like it does in the cell instead of the mm/dd/yy and I know it can be done I have seen it done in 2000 ver I just dont remember how to do It, PLEASE help me out. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel validation drop-down: how show codes with descriptive info? | Excel Discussion (Misc queries) | |||
| excel should show 4 dimensional charts | Charts and Charting in Excel | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
| Reflect file path (show drive letters) in Excel 2000 | Excel Discussion (Misc queries) | |||
| How do I show excel worksheets on a webpage when viewed by win98 . | Excel Discussion (Misc queries) | |||
Threaded Mode
