| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Likely, your data is just text, then. You can try fixing it with "data isn't
recognized" at: http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "bondam" wrote in message ... I want to format a column that contains date and time and I want it to show just the date and not the time. Going into format and clicking on the date and changing doesnt work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Cells - Date options | Excel Discussion (Misc queries) | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| split combined Time Date cells | Excel Discussion (Misc queries) | |||
| Subtracting time in date format | Excel Worksheet Functions | |||
Hybrid Mode
