Date Format (No Time)
 

I want a date format without the time stamp. I have cell formatted as
mm/dd/yyyy; however, when I export to Crystal Reports, it converts to
date/time. How do I strip the time from the date in Excel?
--
MKnepper

Date Format (No Time)
 

=INT(A2) or =TEXT(A2,"mm/dd/yyyy"). The latter, not surprisingly, gives
text, rather than a number which can be used in further calculations.
--
David Biddulph

"MKnepper" wrote in message
...
I want a date format without the time stamp. I have cell formatted as
mm/dd/yyyy; however, when I export to Crystal Reports, it converts to
date/time. How do I strip the time from the date in Excel?
--
MKnepper

Date Format (No Time)
 

I tried =INT however that pulls data into Crystal as a string. Once
formatted, I need it to remain as a date.

Any other suggestions?
--
MKnepper


"David Biddulph" wrote:

=INT(A2) or =TEXT(A2,"mm/dd/yyyy"). The latter, not surprisingly, gives
text, rather than a number which can be used in further calculations.
--
David Biddulph

"MKnepper" wrote in message
...
I want a date format without the time stamp. I have cell formatted as
mm/dd/yyyy; however, when I export to Crystal Reports, it converts to
date/time. How do I strip the time from the date in Excel?
--
MKnepper