| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I formate cells in excell to show inputed date as 09/13/
I have been trying to format colum A to show dates of financial transactions.
I would like to be able to do this in the traditional way of mm/dd/yy. Any help anyone could offer me would be greatly appreciated. I was ok on previous versions of Excell, but frankly, I am lost on this version. -- Dave Wentz |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I formate cells in excell to show inputed date as 09/13/
Select the column
Click Format Cells Number tab Choose "Custom", then in the "Type:" box, enter: mm/dd/yy -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Dave Wentz" wrote: I have been trying to format colum A to show dates of financial transactions. I would like to be able to do this in the traditional way of mm/dd/yy. Any help anyone could offer me would be greatly appreciated. I was ok on previous versions of Excell, but frankly, I am lost on this version. -- Dave Wentz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Lock date in multiple cells | Excel Worksheet Functions | |||
| Weird dates appear in cells when I use Date format! Why? | Excel Discussion (Misc queries) | |||
| Combine Date & Time Cells | Excel Discussion (Misc queries) | |||
| Date Formatted Cells | Excel Worksheet Functions | |||
| Show a date based on today | Excel Worksheet Functions | |||
Linear Mode
