L Lamb Chop Jun 7, 2006 #1 How to convert date to text? e.g 13-05-2006 (in date format) to 20060513 (as text) Thanks Man
C Chip Pearson Jun 7, 2006 #2 Use a formula like =TEXT(A1,"yyyymmdd") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Use a formula like =TEXT(A1,"yyyymmdd") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
D David Biddulph Jun 12, 2006 #3 Lamb Chop said: How to convert date to text? e.g 13-05-2006 (in date format) to 20060513 (as text) Click to expand... =TEXT(A1,"YYYYMMDD")
Lamb Chop said: How to convert date to text? e.g 13-05-2006 (in date format) to 20060513 (as text) Click to expand... =TEXT(A1,"YYYYMMDD")