Mixed formats on dates

  • Thread starter Thread starter Paul Proefrock
  • Start date Start date
P

Paul Proefrock

I have a spreadsheet that has a date column and the users have mixed the
formats.

The column is formated as a date as m/yy. But somehow, there are entries of
numbers in a similar format. Those display like 01/02.

If I try to change the format to text, then those fields that are a date
turn to a 5digit number, those that are numbers stay in their format.

Is there a way to correct these into one or the other format? I am trying to
import this into an Access database and it keeps creating an error. The
problem is the mixed format. (I am aware of the trick of saving a
spreadsheet as a webpage and importing html, but this still creates a
problem with these mixed fields)

Thanks

Paul P
 
Paul,

Select the entire column, and format it as you want (Format - Cells -
Number - Date). The 5-digit number you saw is the underlying date-serial
number for that date.
 
Back
Top