Home » Any Answers » Excel Formatting Issue

Excel Formatting Issue

Posted by Anonymous PM | on Thu, 21/01/2010 - 14:54  1298  7 comments | report

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 | Thu, 21/01/2010 - 15:02

Thank you

Anonymous | Thu, 21/01/2010 - 15:23

Making Dates from Strings using Formula

RichardWhight | Tue, 26/01/2010 - 13:08
RichardWhight's picture

Formating

Anonymous | Thu, 28/01/2010 - 12:51

.

RichardSchollar | Thu, 28/01/2010 - 17:28

Ctl H

Anonymous | Thu, 28/01/2010 - 20:35

Try text to columns

Anonymous | Wed, 10/02/2010 - 17:22