Edit/ Find and Replace/ change @ to a space
or
=--SUBSTITUTE(A1,"@"," ") and format appropriately,
but in either case don't forget to tell your system (in Windows Regional
Settings under Control Panel) whether you are working in dd/mm/yy or
mm/dd/yy, as 12/01/08 is ambiguous.
--
David Biddulph


"Jon M" wrote in message
...
Rec'd date/time data as: "12/01/08@12:05 PM". Does anyone have an easy way
to
conver this to date-time data for calculation in Excel?????