| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Drop AM and PM from date
The text in the cell reads:
05/23/2005 17:23:31 but the actual data that shows in the formula bar at the top reads: 5/23/2005 5:23:31 PM I need the data to reflect the first format. How? |
|
#2
|
|||
|
|||
|
Change the cell format to dd/mm/yyyy hh:mm:ss
******************* ~Anne Troy www.OfficeArticles.com "EMG03" wrote in message ... The text in the cell reads: 05/23/2005 17:23:31 but the actual data that shows in the formula bar at the top reads: 5/23/2005 5:23:31 PM I need the data to reflect the first format. How? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| Date format on a drop down box | Excel Discussion (Misc queries) | |||
| Create a drop down in XL cell to select date | Excel Worksheet Functions | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Linear Mode
