Hi
bad news - you need to change the format of all the cells
good news - you don't need to retype them
to sort or do anything with dates Excel needs to recognise them as dates (ie
like th 38110 one) ... somehow or other your dates have been entered as
"text" and this is why you can't do anything with them.
to change it, type the number 1 into a blank cell (that's not formatted as
text - ie it should go right aligned after you press enter)
copy it
select all the "date" cells that you need to change the format on (if they
are all consecutive, click on the first, hold down your shift key and click
on the last cell in the range - if they're not consecutive, click on the
first, hold down your ctrl key and then click on each cell you want to
include keeping the ctrl key down) ... once you have all your cells let the
shift or ctrl key go
choose EDIT / PASTE SPECIAL from the menu
choose MULTIPLY
click on the Ok button
-the cells should all go like 38110
now keep the cells selected, choose FORMAT / CELL from the menu
choose
Date (under the number tab) and select whatever format you want
Click OK
and it should now be "fixed"
let us know how you get on
Cheers
JulieD
plumstone said:
It is just the same of the natural appearance of the cell: "5/7/04" in the sample area.
If I type some new data in that cell like:"05/07/04", then in the sample
area it shows 38110. And the date is going to return to normal and I can
sort them by date and time or change to any format I want.
But I do not want to retype all of those date and time and I want to sort
them in date, while it refuseds to be either changed in format nor sorted by
date and time.
