=DATE (year,month,day) Assuming your date as text refers to 1 January 2013 then your formula would be: =DATE ("20"&RIGHT (A1,2),MID (A1,3,2),LEFT (A1,2)) That is the British format of day, month, year.
But sometimes some users uses slash sign to separate it which I don't want.Use the DATE function. I want the user to use dash sign to separate country code, std code, area code and phone number with dash sign only. For example: Pages 2–4 100–150 peopleReplace slash sign to dash sign Hi friends, Greetings from me! In column there are phone numbers. For example: Between times: 1200–1600 or 6 am–8 am Between days: Monday–Friday Between dates: 12–15 October Between months: June–August Between years: 1967–1969 The dash can be used for any range. A …Using Dashes between Ranges (e.g., Date Ranges) The dash is used between ranges.
Old_text - the original text (or a reference to a cell with the original text) in which …Show Answers Dashes The dash functions almost as a colon does in that it adds to the preceding material, but with extra emphasis. As you see, the Excel REPLACE function has 4 arguments, all of which are required. What function could you use to replace slashes for dashes in a list of dates.
0 kommentar(er)
