ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Date Formatting change (https://www.excelbanter.com/excel-worksheet-functions/9829-date-formatting-change.html)

PaulG

Date Formatting change
 
I have dates in a column formatted as yyyymmdd. I want to change the format
to MM/DD/YY.

Thanks

Bob Phillips

Select the column, Go to FormatCellsCustom and input"MM/DD/YY"

--

HTH

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


"PaulG" wrote in message
...
I have dates in a column formatted as yyyymmdd. I want to change the

format
to MM/DD/YY.

Thanks





All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com