| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| format date time | Excel Worksheet Functions | |||
| date time format | Excel Discussion (Misc queries) | |||
| how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
Linear Mode
