Date in numeric format

  • Thread starter mohd21uk via OfficeKB.com
  • Start date
M

mohd21uk via OfficeKB.com

I am trying to format dates in a spreadsheet. These dates are in a mixed
format. They change to a five digit format (for e.g. 06/03/2005 is represnted
by a five digit no. - 38417). I am unable to sort the date because it is not
in the correct format even if I change it to date. Is there any way I can
convert these numbers back to the date format therefore allowing me to sort
them.
 
B

bgeier

You need to format the entire column as a date (choose the format yo
want), then select "Data" -> "Sort..." then decide how you want th
dates sorted (ascending, descending
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date in numeric format 2
Date formats 1
How to convert decimal year to date format in excel 2
Date and Number cell formats 4
Weird Excel date formatting problem 2
Excel date format YYYYMMDD 1
Date format 2
how to change format of several dates entered in an Excel column 2

Top