Date in numeric format

[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

 

[Bob Phillips]

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)

 

[Guest]

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!