Excel Formatting Issue

Does any one know a quick method to resolve the issue of a spreadsheet with dates entered as text

e.g "10.12.2008"

instead of being entered in the date format. As I wish to be able to sort the spreadsheet by date.

Comments
There are 7 comments. Login or register to view them.

.

RichardSchollar |

Thank you

Anonymous |

Making Dates from Strings using Formula

RichardWhight |
RichardWhight's picture

Formating

Anonymous |

.

RichardSchollar |

Ctl H

Anonymous |

Try text to columns

Anonymous |