| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert text 'Jun-30-2007' to date format?
How to convert text to date format so that I can calculate in excel? Thanks.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to convert text 'Jun-30-2007' to date format?
Kenny
if it is in a format that can be recognised by Excel (dd/mm/yyyy, mm/dd/yyyy, dd-mm-yyyy, etc) then use =DATEVALUE(A1) Where A1 has the text date. Then format the resulting serial number as a date If you only want to 'kick' the text dates to proper dates, try copying a blank cell, highlighting the 'text dates' and then EditPaste special...Values+Add. Then format the serial number as date -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "kenny" wrote in message ... How to convert text to date format so that I can calculate in excel? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to convert text 'Jun-30-2007' to date format?
Data Text to Columns Next Next Under Column data format select Date
Finish "kenny" wrote: How to convert text to date format so that I can calculate in excel? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert text into date format? | Excel Discussion (Misc queries) | |||
| How to convert text into date format? | Excel Worksheet Functions | |||
| Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
| Convert Text Entry to Date Format | Excel Discussion (Misc queries) | |||
| Date format not correct when you convert a CSV text file in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
