Date in numeric format

  • Thread starter Thread starter mohd21uk via OfficeKB.com
  • Start date 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. Mnay thanks in advance
 
Dates are just numbers with a special representation in the spreadsheet.
Sorting should work regardless of how they are formatted.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Hi!

You can revert the 5-digit format back to the usual date format by:

(1) Select first the range with the data
(2) Go to Format then Cells then Number tab then Date.
(3) Select the desired date format then OK

Hope this helps!
 
Back
Top