Hi Rick,

Yes, 07/12/2007 04:47:32 PM WET is just a text right now.
For your second question, yes, when I say to do the conversion, I mean
replacing this Date: 07/12/2007 04:47:32 PM with this one: 7/12/2007
12:47



I think would need a formula to do it, but I don't how to proceed as I
am not yet good on Excel.



In one of my excel sheet, I have the Date above, in all of its rows,
and I want to change all of them and look like this one and its
format: 7/12/2007 12:47


Thanks,
Ed


On Aug 1, 8:02*am, "Rick Rothstein \(MVP - VB\)"
wrote:
First off, is that actually a real Excel date in your worksheet, or is it
just Text right now (that is, what does the cell's format show)?

Will all your times be in the same time zone (I'm guessing that is what the
WET is)? If not, you will need to list the possible time zone abbreviations
for us.

When you say "convert", do you mean replace what you showed with what you
want **in the same cell**?

Rick

"Ed" wrote in message

...



Hi All,

Does anyone know how to convert this date: *07/12/2007 04:47:32 PM WET
to the following one : 7/12/2007 12:47

Is there any date command you know I may use?

Thanks,
Ed- Hide quoted text -

- Show quoted text -