Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:Tagretaining text format Hi, I have this problem when I scrap data in the format of XXXX-XX-XX but when I open the Excel file it turns into a date format as follows: How do I keep the original format I scrapped? Thank you Re: converting text to date format OliverScheurich Hey, both work perfectly. Thank you so much! Re: converting text to date format OliverScheurich Thank you! 2 problems that I still have: The formula does not apply for years 2000's and 90's and so on.. for example- 12026-09-10 866-03-08 I also have these types of strings which should return the year only- 5904-06 58224-07 2209-04 3529-08 Re: converting text to date format OliverScheurich It does, thank you so much! However, I cannot change the date format at all. is there a way to overcome this? Thanks Re: converting text to date format OliverScheurich yes for the month, not for the year.. converting text to date format I need to convert the following text format into a date format so that the 1st sequence of numbers will be deleted, the 2nd sequence will be treated as the month, and the 3rd will be the year. See the example below. How should I use the text-to-columns function properly to reach that? 30858-05-22 May-22 37020-11-22 November-22 14858-06-22 June-22 30333-01-22 January-22 65113-04-21 April-21 6165-07-16 July-16 SolvedRe: ungrouped datesYou are right, they are not left-aligned. What should I do then?ungrouped dates Hello, I have a list of dates - some of them are grouped by the year in the filtering and some are not (see below). How can I fix it so that all of the dates will be grouped by the year? How to disable active content alert? How can I disable this alert when I click on a link to an external website? Re: can't disable security noticeThank you so much!can't disable security notice I keep getting these security notices for every hyperlink I'm trying to open. How can I disable them? Solved
