ExcelBanter - converting dates

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - converting dates (https://www.excelbanter.com/excel-programming/291933-converting-dates.html)

mike

converting dates

There must be a simple way to convert 1/15/04 to 011504
and 1/6/04 to 010604.

Any help would be greatly appreciated. Thanks.

Frank Kabel

converting dates

Hi
try formating (Menu: 'Format - Cells') the cell with the custom format:
MMDDYY

--
Regards
Frank Kabel
Frankfurt, Germany

mike wrote:
There must be a simple way to convert 1/15/04 to 011504
and 1/6/04 to 010604.

Any help would be greatly appreciated. Thanks.

Grey Newt

converting dates

Did you want a cell format or a VBA solution ?

All times are GMT +1. The time now is 10:33 AM.