Time Format Problem


John Calder


I run Excel 2K

I have a column of dates that are downloaded from a mainframe. The date
format of these are 18/08/2009 7:58:00 AM.

I am trying to contruct a pivot table that looks at these dates and allows
me to pick a date range for the pivot table. I have the formula to do this
which I have used many times. The problem I have is because there is a time
included in the download it does not allow my formula to work correctly.

How can I reformat the date to exclude the time component. Or, is there a
formula that I can use that strips the time component?

I have tried a custom format which forces it to be displayed as 18/08/2009
in the cell however it still shows 18/08/2009 7:58:00 AM in the edit bar.



T. Valko

Formatting only changes the *display*. It doesn't change the true underlying
value of the cell.

You can strip off the time like this:

A1 = 18/08/2009 7:58:00 AM


Format as Date

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question