dates and text

Hi all. i searched the board and i found how to convert dates (which didn't work for me) and there is lots of info on how to convert dates, BUT the data that im receiving is DUMB because im getting MIXED data and excel can read SOME of it but not all of it... and its SUPER anoying... is there a...

Hello everyone! I am having the toughest time formatting a spreadsheet with copy pasted data. For my purposes, I require all formatting to be "removed"; that "9/6, 12/1, 5/6", et al are not seen as dates, however like they are manually entered values with no format. Because Excel is thinking...

How can I format the dates on a sheet from this "2016 Week 1" to this: "2016 Week 01" instead of doing a control find and replacing the 1 to a 01. I want the dates in that order so when I do the pivot table update, it has them in order instead of week 1 and then week 10.

I am trying to return a value when searching multiple criteria including a date range. For example- Column A= Time of Error Column B= Description of Error Column C= Would like Return of Error Message 500 only during a certain time. A1 05/10/2016 12:00 B1- Customer Receives Error 500...

Hi, I would like to enter a date and text in the same cell. When I auto-fill a series of dates with my preferred date format, and then attempt to enter text in some of the cells, the date format changes. I want to have 6-May, but when I enter text to follow the date, it changes to 5/6/2016. In...