How to convert date to text

G

galsaba

I have a field - date. Let's say that one of the values is 6/20/05.
How can I convert it to a number field, for example 6/20/05
will be shown as 20050605?

Thanks,

galsaba
 
B

Bob Phillips

=TEXT(A1,"yyyymmdd")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Bernard Liengme

Try =YEAR(A1)*10000+MONTH(A1)*100+DAY(A1)
But you MUST format the cell after typing the formula because Excel wants a
date format
 

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

How to convert date to a number (special) 1
Converting a non recognizable date time 1
Problem formatting dates from CSV file 2
Windows 7 I need to convert date to text 3
Date Overdue function, Macro, or VBS 5
convert number to date in excel 2003 2
convert date to text 2
Calculate a future date, not including Sat/Sun or Bank Holidays 3

Top