| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change number text to Date format?
Thank you so much!
-- Have a great day! "Jacob Skaria" wrote: --Select the range of dates in col AB 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 (YMD). --Hit Finish. MSExcel will now convert the dates to the default date format of your computer. If this post helps click Yes --------------- Jacob Skaria "Doug" wrote: I have a table, and in column AB there are numbers that are entered as general text. yyyymmdd is the format that I would like excel to recognize them in. How can I accomplish this task? -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
| Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
| Hoe to change text format .126 to number format 0.126 | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
| Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming | |||
Threaded Mode
