Date help

[lee009]

I have a column filled with dates; some dates have the exact date listed, others just the month & year. Is it possible to have the cells that have the month & year populate the same as the exact dates? Example:

12/1/2019
12/1/2019
12/1/2019
dec-2018

Is it possible for the cell that shows 'dec-2018' to show 12/2018?

 

[Joe4]

Are you sure that they don't all have complete dates, and are just formatted differently?
What happens if you select the WHOLE column and change the format of the column to a custom format something like mm/yyyy?
Do all the values change?

If not, then some are formatted/entered in as Text.