| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
month & year format in two digits
Hi folks....
is this possible in excel that if I just type MM/YY without this "/" and it appears as MM/YY. For example if I type 0805 in the cell it should appears as 08/05 once entered. Help will be appreciated. Thanks Morphyus -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200508/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Format | Excel Discussion (Misc queries) | |||
| HELP with this function | Excel Worksheet Functions | |||
| How do I convert a serial number to the month, day, and year in E. | Excel Discussion (Misc queries) | |||
| How can I format a cell so date field only displays the Month? | Excel Discussion (Misc queries) | |||
| Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
Threaded Mode
