Solved changing date format to yyyymmdd

May 15, 2012 at 04:47:30
Specs: Windows XP
I have a date in dd/mm/yyyy. How do I change it to yyyymmdd automatically in EXCEL

See More: changing date format to yyyymmdd

Report •

Report •

May 15, 2012 at 07:36:25
✔ Best Answer
You will need to use a Custom Format

Right click on the cell with your Date
Select Format Cells
Select Custom, at the bottom of the popup window

In the small input box, under the word Type:
delete what ever is in the box and enter:


Click OK

As long as your cell contained an actual date then you should see it change.


Report •

Related Solutions

Ask Question