ExcelBanter - Drop AM and PM from date

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Drop AM and PM from date (https://www.excelbanter.com/excel-worksheet-functions/36352-drop-am-pm-date.html)

EMG03

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?

Anne Troy

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?

All times are GMT +1. The time now is 01:03 AM.