| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dates from inhouse system download as text.Convert back to date?
When I download a report from our inhouse system to excel the dates appear as
text. Can I convert them back to dates - and if so - how? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dates from inhouse system download as text.Convert back to date?
--Select the range of dates which needs to be corrected.
--From menu DataText to Columns will populate the 'Convert Text to Columns Wizard' Hit NextNext will take you to Step 3 of 3 of the Wizard. --From Column Data format select Date and select the date format in which your data is (MDY or DMY or what ever it is) . --Hit Finish. MSExcel will now convert the dates to the default date format of your computer. If this post helps click Yes --------------- Jacob Skaria "ShazBat" wrote: When I download a report from our inhouse system to excel the dates appear as text. Can I convert them back to dates - and if so - how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert military date system to standard date system | Excel Discussion (Misc queries) | |||
| Excel - convert dates to text but appear as a date format | Excel Discussion (Misc queries) | |||
| NEED HELP..CONVERT NUMBERS BACK TO TEXT | Excel Discussion (Misc queries) | |||
| to convert a julian date back to regular date | Excel Worksheet Functions | |||
| Convert SERIAL date back into dd/mm/yy format? | Excel Worksheet Functions | |||
Hybrid Mode
