On Mon, 5 Dec 2005 01:58:02 -0800, "MijC"
wrote:

Wonder if anyone can help.
In column A there is a date and time function in the format as follows :
dd/mm/yy hh:mm:ss most of the time.
When this is downloaded it is easy to manuplite. But some times it show as
above but as a text string or sometimes the dd/mm is switched to mm/dd.
Does anyone know the work rounds these formulas?

I use the dd/mm and Hr function to complie reports from column A but usually
spend hours using mid() left() function due to the date change.
I have tried formating the cell but this does not work?

Help
MIJC

What is the function in Column A? (Excel has many date and time functions).

What are the inputs to the Column A function and what do you obtain for outputs
or display?

When you say the dd/mm is switched to mm/dd, is that in the downloaded data or
is that after you have performed some Excel operation on the downloaded data?

Are you perhaps not using the word "function" as it is used in Excel, but
rather merely mean that you are downloading date/time strings from the "web"
into column A? If that is the case, it is likely that all of the strings in
Column A are, in fact, text strings. This can be easily determined by using
the formula =ISTEXT(A1) in some unused column and copying it down as far as
necessary.


--ron