ExcelBanter - change 04/02/07 to 040207

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

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

- - change 04/02/07 to 040207 (https://www.excelbanter.com/excel-discussion-misc-queries/143218-change-04-02-07-040207-a.html)

change 04/02/07 to 040207

change 04/02/07 to 040207

How do I can the cell to display change 04/02/07 as 040207

Mike H

change 04/02/07 to 040207

I assume it's a date and not text so try a custom format of

ddmmyyyy

Mike

"change 04/02/07 to 040207" wrote:

How do I can the cell to display change 04/02/07 as 040207

CLR

change 04/02/07 to 040207

And if it IS text..........

=LEFT(A1,2)&MID(A1,4,2)&MID(A1,7,2)

Vaya con Dios,
Chuck, CABGx3

"change 04/02/07 to 040207" wrote:

How do I can the cell to display change 04/02/07 as 040207

All times are GMT +1. The time now is 02:12 AM.