ExcelBanter - convert date to text

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - convert date to text (https://www.excelbanter.com/excel-discussion-misc-queries/92645-convert-date-text.html)

Lamb Chop

convert date to text

How to convert date to text?

e.g

13-05-2006 (in date format)

to

20060513 (as text)

Thanks

Man

Chip Pearson

convert date to text

Use a formula like

=TEXT(A1,"yyyymmdd")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Lamb Chop" wrote in message
...
How to convert date to text?

e.g

13-05-2006 (in date format)

to

20060513 (as text)

Thanks

Man

David Biddulph

convert date to text

"Lamb Chop" wrote in message
...
How to convert date to text?

e.g

13-05-2006 (in date format)

to

20060513 (as text)

=TEXT(A1,"YYYYMMDD")
--
David Biddulph

All times are GMT +1. The time now is 03:56 PM.