| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changine text into a date
Great stuff very helpful. Thank you....
"Bernard Liengme" wrote: Select the range of cells to be converted Use Data | Text to Columns Use Delimits, click Next until you get to step 3 Set Date box to YMD and press finish Done! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Crauwf" wrote in message ... I have the following date 20081128 How do I convert this figure to the date 28/11/2008? Can anyone help? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert a text date to a true date | Excel Discussion (Misc queries) | |||
| how do i change text format date to date (i.e., mm/yy to mm/dd/yyy | Excel Discussion (Misc queries) | |||
| how do i convert text to date (mm/yy text to mm/dd/yyyy date)? | Excel Discussion (Misc queries) | |||
| Concatenating a Text and a Date without losing orginal Date Format | Excel Discussion (Misc queries) | |||
| Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
Threaded Mode
