dates as text

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...

Using Excel 2016 I have a dataset which has dates in row 1. when the range is converted into a Table, row 1 becomes my table headers and excel treats all column headers as Text regardless of the previous data type. I have the following formula which when the dataset is stored as a range, and...

I am working with a range of dates that tasks were completed. However some of the cells are blank because the tasks are in process. I need a formula to return the most recent date indicated in the rage once all of the cells in the range have completed dates by them. GG

I have a column with the following values: <tbody> SubmitDate November 8, 2012 1:37:07 PM GMT+05:30 November 8, 2012 9:32:03 AM GMT+05:30 November 8, 2012 4:32:54 AM GMT+05:30 November 7, 2012 10:28:11 PM GMT+05:30 November 7, 2012 8:36:43 PM GMT+05:30 November 7, 2012 6:33:13 AM...

I feel like this is a pretty simple question to answer but I cant find an answer to it anywhere or I'm just not skilled enough to understand it. I have two columns D and E that have dates in them. Column D is the purchase date of a computer and column E is how many years months and days its...

Hi, I'm setting up some workbooks for the new financial year 2012-13 and I've got a problem with a workdays formula that has worked perfectly well for this current year, 2011-12. Here is the formula...

When I import a report into Excel, often the dates come over and some of them are text while others are recognized dates. I think it because the order of the months and days is not what Excel is expecting. See image: Does anyone know the best way to fix this in Excel as oppose to on the...

Could someone help me please. Below is an example entry in a single cell. I am parsing the different elements out into separate columns. 16 Aug Payment to xxx Type of payment yyy Amount £zzz<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> The...

Hi, again thanks for previous help, I would not ask had I not tried several times already, but my new question is this: I have a column listed as the ID tag for a dataset. This column has a large number for every row, with numbers representing different values of the identification, and...