I have this below
8/26/2005 3:19:00 PM
I only want to display
8/26/2005
Can't figure out how to do this. I tried changing the date format to just
date, but it still displays the time. Please help
I have this below
8/26/2005 3:19:00 PM
I only want to display
8/26/2005
Can't figure out how to do this. I tried changing the date format to just
date, but it still displays the time. Please help
First, make sure what you have in your cell is truly an "Excel Date" (which is a number that Excel interprets as a date) by changing the format of the cell to General. The cell should now show the "Date Number" of 38590.63819 (or similar). If it still shows "8/26/2005 3:19:00 PM", then what you have is a TEXT entry and changing the format will not alter it.
What do you find?
Bruce
The older I get, the better I used to be.
USA
=int(A2)
assuming it is a real date and timne cell. Format the cell as just date.
Actually, you could just format the original cell as date. The time will
still be there, it just won't show.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"HeartSA" <[email protected]> wrote in message
news:%[email protected]...
> I have this below
>
> 8/26/2005 3:19:00 PM
>
> I only want to display
>
> 8/26/2005
>
> Can't figure out how to do this. I tried changing the date format to just
> date, but it still displays the time. Please help
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks