| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert a text in a date format
Hi
I have imported a file where there is a field that is suposed to contain a date. It was transformed in text, like 22FEB2010. I need to treat this field as date. How can i transform it in a date format? Tks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert a text in a date format
xBeckx wrote:
Hi I have imported a file where there is a field that is suposed to contain a date. It was transformed in text, like 22FEB2010. I need to treat this field as date. How can i transform it in a date format? Tks Copy a blank cell. Select your "dates". Edit / Paste Special / Values / Add / OK. Result will be a 5 digit number. Select date format as desired. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert a text in a date format
Another method.
DataText to ColumnsFinish. Gord Dibben MS Excel MVP On Mon, 17 May 2010 09:56:01 -0700, xBeckx wrote: Hi I have imported a file where there is a field that is suposed to contain a date. It was transformed in text, like 22FEB2010. I need to treat this field as date. How can i transform it in a date format? Tks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| from date format convert to text format is wrong | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| 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 | |||
Hybrid Mode
