Convert Date to Text

C

char needs text

Is there an easy was to convert date field to text without it converting to a
serial number. Right now I take the date field, convert text to column, add
the two columns with a / then concatenate the five columns, then copy paste
special with values only.

Seems like a long process for simple text. Any suggestions?
 
D

David Biddulph

If you are starting with an Excel date, them merely =TEXT(A2,"dd mmm yyyy"),
adjusting the formatting characters to suit your preference.
 
H

HKaplan

Try =TEXT(A1,"dddd mmmm yyyy")

Where A1 has the data info. You can change the display format, such
as dd/mm/yy or whatever you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 7 I need to convert date to text 3
from date format convert to text format is wrong 2
Convert date to text 6
converting date to text 2
Convert Numbers to Text 4
convert text to date 2
HOW DO I CONVERT A .TXT FILE TO EXCEL 2
Automatically convert Text with 2-digit year 2

Top