I'm trying to build a timeline in powermap but I'm having some problems getting things to format correctly.

The month of October seems to be programmed incorrectly in Excel 2013.

Formatted Incorrectly

Formatted correctly

• Edited by ResidentX10 20 hours 4 minutes ago

October is formatted correctly - you have chosen a date time format that does not show seconds - because it is an actual date.  The others are not dates but strings that look like dates - there is no 9/31 or 11/31, so Excel leaves them as strings, which will not change how they are displayed as the cell format changes.

• Edited by Bernie Deitrick, Excel MVP 2000-2010Microsoft community contributor 17 hours 7 minutes ago
• Marked as answer by ResidentX10 17 hours 5 minutes ago

I used the same format for both...look at the pictures. October didn't format correctly or the others didn't. Which is it so I can get this fixed? 

Yes, you used the same format for both but 9/31 and 11/31 are NOT DATES. So they are strings, and formatting does not affect the displayed value.

Change the formatting to Custom, with the string

m/d/yyyy hh:mm:ss AM/PM

and the October dates will look the way you want.  But those are DATES not STRINGS, and so you need to be careful - change 9/31 to 9/30 and 11/31 to 11/30 and those entries will be dates, too.

Strings are left-justified, dates and numbers or right-justified. And when you change the format to number (the columns on the right), the display of dates change to numbers with decimals. Strings don'tchange.

• Edited by Bernie Deitrick, Excel MVP 2000-2010Microsoft community contributor 15 hours 39 minutes ago
• Marked as answer by ResidentX10 15 hours 1 minutes ago

I'll apply custom formatting Thanks but why add the "date" formatting if you have to do custom. Weird but thanks for the solution. 

• Edited by ResidentX10 15 hours 1 minutes ago