Date in numeric format
 

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200605/1

Date in numeric format
 

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


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=542043