katiapro93
Board Regular
- Joined
- Jun 25, 2009
- Messages
- 140
Hello Everyone, I need help again. I have a spreadsheet that has a column with a date and military time which I want to seperate into two columns. When I do that thru delimiting it under the Data tab, the time column looses its military format. I need to keep the military time and I don't see anything under cell format that helps. Any ideas? Example below:
3/29/13 13:23:01 It becomes 3/29/13 and 1:23 p.m. I need it to stay as 13:23:01
3/29/13 13:23:01 It becomes 3/29/13 and 1:23 p.m. I need it to stay as 13:23:01