Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Strip Out Time
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 |
#2
|
|||
|
|||
=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" wrote in message ... 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 |
#3
|
|||
|
|||
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? -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=475984 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time and motion chart | Charts and Charting in Excel | |||
Excel Time Manipulation | Excel Discussion (Misc queries) | |||
conditional formatting with time values | Excel Discussion (Misc queries) | |||
Time Sheets | New Users to Excel | |||
unmet challenge | Excel Worksheet Functions |