Charlene wrote:
how do I change the date format from yyyymmdd to mm/dd/yyyy

If your data is actually numbers that look like dates in the format "yyyymmdd",
then you would need to do something like this:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))