Convert date field into text in Excel [duplicate]

Question

This question already has an answer here:

• Excel Date to String conversion 9 answers

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 1

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

Answer 2

If that is one table and have nothing to do with this - the simplest solution can be copy&paste to notepad then copy&paste back to excel :P

Answer 3

You can use TEXT like this as part of a concatenation

=TEXT(A1,"dd-mmm-yy") & " other string"