P Paul Aug 12, 2004 #1 What formula would convert this date and time into just the day month / day / year 8/11/2004 4:53:44 PM Thanks
What formula would convert this date and time into just the day month / day / year 8/11/2004 4:53:44 PM Thanks
B Bob Phillips Aug 12, 2004 #3 You could just format it with a date format, or take the integer value =INT(A1) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
You could just format it with a date format, or take the integer value =INT(A1) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
