[AccessD] OT - Excel Date Formatting

Hi Mark!

Can you not just change the formatting of the column from mm/dd/yyyy h:mm:ss
to mm/dd/yyyy in the format cells dialogue?

If this is not quite what you want reply to me as I've got a hand-rolled
function to convert Excel dates/times to text.

Regards
Chris Foote - UK

> -----Original Message-----
> From: Mitsules, Mark S. (Newport News) [mailto:Mark.Mitsules at ngc.com]
> Sent: Monday, June 14, 2004 2:16 PM
> To: '[AccessD]'
> Subject: [AccessD] OT - Excel Date Formatting
> 
> 
> Group,
> 
> What is the simplest way to transform a column of dates...?
> 
> >From this: 5/3/2004  2:41:33 PM
> To this: 5/3/2004
> 
> Currently I'm using =MONTH(D2)&"/"&DAY(D2)&"/"&YEAR(D2), then 
> copying and
> using Paste Special (Values) to get the desired result.  Is 
> there a better
> way?
> 
> Thanks,
> 
> Mark
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>