For me Excel accepted "05.22 01:15 pm" and converted it to real Excel
date/time format. If so, simply format cells with this custom format code:
dd mmm h:mm AM/PM

Regards,
Stefi

€žPeter Glebe€� ezt Ã*rta:

I have some experience of using Excel (2003), but cannot do anything other
than very simple VBA. I have a piece of equipment (a blood glucose monitor),
which, being of US origin, displays dates as "05.22", when it means "22nd
May". It displays times as "01:15 pm".

I wish to plot my blood glucose levels, and would like to enter the dates
and times in the format shown on the instrument - either in one column or two
(date and time separate). Obviously, it would be nice to display dates in
the English format I am used to (22/5 instead of 5/22), but this is not so
important as being able to plot them. Is there any way I can persuade Excel
2003 to accept "05.22 01:15 pm", in one cell or two, and recognise these -
singly or in combination, as "22 May, 1.15 pm", so that I can create a chart
showing the correct date and time?

--
Peter