How do I add a leading zero to a date?

I have imported a DBF file into Excel and have a column of dates that are missing the leading zero on single didgit months. When I try to us the custom format of mm/dd/yyyy it doesn't work (interestingly, after I select that format if I click on an individual cell it changes to the right format).

Does anyone know a better way to do this?

Thanks in advance!

try this:

format the column to the format that you want. Then highlight all of the dates>copy>paste special>values (into the same cell range). They should be the correct format

Unfortunately, that doesn't seem to work. It stays the same. It will change format while clicking on the individual cell, but there are roughly 8000 rows that need to be modified.

ok. It seems that your dates are formatted as text. This is what you should do.

first, on a blank cell somewhere on the sheet, type the number 1. then, right click, copy.
next, highlight the entire column of dates. right click, paste special, multiply.
all of the dates will have turned into numbers.
next, highlight the date column, and apply the date format that you want.

let me know if it works

Like a charm! Nice trick, thanks very much!!!

Glad it worked out for you

Thank you BigBas, this was very helpful to me too! I got it to work easily. I frequently have to reconcile dates in US format to European format and there is always some little bug in the formatting that makes me have to do them 1-by-1, ugh! This trick will get lots of use! Many thanks again!