Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formatting dates
I have some data that was sent to me that needs to be manipulated.
The data includes date/times in a column that I want to reformat into the date/military time format. The original spreadsheet had the date time format as custom. When I try to reformat the cells, the appearance does not change. That is to say that, for example, a 2:00 PM time still appears that way instead of as 1400. Any idea why the reformatting of the cells does not appear to be catching on? TIA for any input. |
#2
|
|||
|
|||
Sounds like your data is being seen as text. Force Excel to see the values.
See "Data Isn't Recognized.." http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "Papa Jonah" wrote in message ... I have some data that was sent to me that needs to be manipulated. The data includes date/times in a column that I want to reformat into the date/military time format. The original spreadsheet had the date time format as custom. When I try to reformat the cells, the appearance does not change. That is to say that, for example, a 2:00 PM time still appears that way instead of as 1400. Any idea why the reformatting of the cells does not appear to be catching on? TIA for any input. |
#3
|
|||
|
|||
Select the cell, go to Format, Cells, Number, custom - scroll down to hh:mm,
that's the one you need. But, in the type box, remove the colon, click OK. The date will appear as 1400 and not 14:00 "Papa Jonah" wrote: I have some data that was sent to me that needs to be manipulated. The data includes date/times in a column that I want to reformat into the date/military time format. The original spreadsheet had the date time format as custom. When I try to reformat the cells, the appearance does not change. That is to say that, for example, a 2:00 PM time still appears that way instead of as 1400. Any idea why the reformatting of the cells does not appear to be catching on? TIA for any input. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates Not Formatting as Dates | Excel Worksheet Functions | |||
conditional formatting overdue dates | Excel Discussion (Misc queries) | |||
conditional formatting overdue dates | Excel Discussion (Misc queries) | |||
Formatting dates on x axis of chart...! | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions |