how do I change the date format from yyyymmdd to mm/dd/yyyy
highlight the range, right click on the mouse, custom format, type mm/dd/yyyy
Format/ Cells/ Number/ ...
If your data is actually numbers that look like dates in the format "yyyymmdd",
then you would need to do something like this:
Data>Text to Columns>Next>Next>Column Data Format>Date>YMD and Finish
Gord Dibben MS Excel MVP