D
DMM
Hi,
I have about 400 cells that contain the date and time in
this format 05/04/04 11:34 CDT
How can I get just the date from these cells so that I can
use them in a pivot table. I know that if I format the
cells as text, I can use the len and left functions but is
there another way so that I can use the results as dates??
Thank you
I have about 400 cells that contain the date and time in
this format 05/04/04 11:34 CDT
How can I get just the date from these cells so that I can
use them in a pivot table. I know that if I format the
cells as text, I can use the len and left functions but is
there another way so that I can use the results as dates??
Thank you