Convert date field into text in Excel

excel excel-formula worksheet-function
brpaz picture brpaz · Apr 3, 2012 · Viewed 338.6k times · Source

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 tried the text function but it gives me Error 508.

Any help?

Answer

barry houdini picture barry houdini · Apr 3, 2012

You don't need to convert the original entry - you can use TEXT function in the concatenation formula, e.g. with date in A1 use a formula like this

="Today is "&TEXT(A1,"dd-mm-yyyy")

You can change the "dd-mm-yyyy" part as required

Related questions

Refer to a cell in another worksheet by referencing the current worksheet's name?

I plan to have a workbook with 24 sheets. The sheet names will be: Jan, Jan item, Feb, Feb item, etc. Basically it's for budgeting, with the month named sheet having summary info, and the ones with "item" in the name …

Read More
How to use VLOOKUP result as COUNTIF criteria

I want to be able to determine how many times a person's particular ID (e.g. #123) has appeared in a separate column (e.g. column C) given a name (e.g. Bob). I have: Let column A consist of several …

Read More
How to extract text within a string of text

I have a simple problem that I'm hoping to resolve without using VBA but if that's the only way it can be solved, so be it. I have a file with multiple rows (all one column). Each row has data …

Read More