Drop AM and PM from date

[EMG03]

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" <EMG03@discussions.microsoft.com> wrote in message
news:7CDA6DDA-043B-45E8-BB8E-B0C8F1D082BF@microsoft.com...
> 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?