quick help in excel

[skisteven1]

I've got a column of dates that are formatted as such:

'03/15/1988'
'03/17/1988'
'04/02/1992'
.....etc

I'd like to sort them by date. If I can remote the apostrophe on each end, then it shoudln't be a problem. I feel like there really ought to be an easy to way to apply expressions to groups of cells in excel, but I don't know how.

Any suggetsions?

 

[HN]

select column -> data -> sort -> column [whatever the column is] -> Ascending / Descending.

i just did it with the apostrophes in place and it still worked.

 

[Ghouler]

1) press ctrl+H
in the first line enter this sign you want to get rid of :
'
leave the other line blank

hit "replace all" button

2) Then mark whole column
press ctrl+1
select number tab, select "date", pick any format you want

3) Sort column whatever way you want now

Does ot work now?

 

[skisteven1]

find and replace doesn't catch the ' , for some reason

 

[bruceb]

Do you have the cells formated as DATE FORMAT ? ?
Select the format that shows as 3/14/2001 in the drop
down list ... When you enter the DATES, if you want the
leading zero to show for months Jan thru Sept hit the '
key first then type in the date ... the zero will stay but the '
will not show