| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date only?
Select the cell(s) you want to format. On the Format menu, click Cells, and then click the Number tab. In the Category list, click Date or Time, and then click the format you want to use. Note If you don’t find what you’re looking for, you can create a custom number format by using format codes for dates and times. (taken from excel help) You Don't have to convert any of the date-time values, just change the cell formatting to change how they are displayed. hope it helps. -- goober ------------------------------------------------------------------------ goober's Profile: http://www.excelforum.com/member.php...o&userid=19838 View this thread: http://www.excelforum.com/showthread...hreadid=489790 |
| 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 | |||
| How do I convert a list of date of births into age in Excel? | Excel Worksheet Functions | |||
| How do I convert Date serial number to date | Excel Worksheet Functions | |||
| convert julian date to gregorian date | Excel Discussion (Misc queries) | |||
| How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) | |||
Threaded Mode
