## Convert date field into text in Excel

I have an Excel file which has a column formatted as date in the format dd-mm-YYYY.

I need to convert that field to text. If I change the field type excel converts it to a strange value (like 40603).

…

Technical knowledge for tech readers and developers

excel-formula

I have an Excel file which has a column formatted as date in the format dd-mm-YYYY.

I need to convert that field to text. If I change the field type excel converts it to a strange value (like 40603).

…

I have a database-like table in Excel 2003, with a single header row containing AutoFilters in row 6, and data from row 7 to -say- row 160. Rows 1 – 5 are the sheet title, column group titles and …

I have Excel documents containing Unix epoch timestamps from a Java application. I’d like to see what they translate to and represent them as human readable dates inside of Excel.

For example, the …

I want to take the left 5 characters of each cell in column E and put them into the adjoining cell in column F:

A…B….C…D……E………………F

123.bb…cc..dd…..90210ABCE13……..90210

…

I have a column of text values with repeated values. I want to create a new column of unique values (no repeats) and a column with the frequency of each of those values.

What’s the easiest way to do …

I have this table and I would like to create a formula which would count values based on true conditions from column A and column C.

Example:

If in column A value is M (male), and in column C is YES,…

I’m trying to create a chart with a range built dynamically using the INDIRECT function. Excel does recognize the range I am creating using INDIRECT as it highlights the corresponding range on the …

I’ve recently discovered that you can use SUBTOTAL for various functions which allow you to sum up or find totals of a column, even whilst there are filters being applied to it.

However, the list of …

I need help on my Excel sheet. How can I declare the following IF condition properly?

if A1 = “n/a” then C1 = B1

else if A1 != “n/a” or has value(int) then C1 = A1*B1

I’m looking to do the equivalent of SUMPRODUCT but with division. Is there a way to add the results from dividing two arrays?

Example: Column A has the “life” of an asset in years (10, 20, 10). …