Changing date format

[percyth1]

How do I change a cells value from this

3/04/2012 5:21:20 p.m.

To this

3/04/2012

Basically erasing any time value off the end

I'm trying to create a pivot table, even if I format cells to the date format (so it just displays 3/04/2012) it still contains the time value within the cell and treats each date as an individual value in the pivot table.

Any help would be appreciated

[JieJenn]

Click on the cell and hit Ctrl + 1, under number tab, select date. From there, you will see a list of available date format options

[percyth1]

It still contains the time value within the cell,

If I turn this
2/04/2012 14:11
2/04/2012 14:31

Into this

2/04/2012
2/04/2012

Via that method, it still treats the two 2/04/2012 in the pivot table as independent values and doesn't total the figures attributed to them.

There must be a formula that would change the value, going through 5000 entries individually deleting the time values off the end would be painful.

I have attached the spreadsheet I have.

[percyth1]

Never mind solved using the round-down formula.