How to Transform Date Text to Date Formatted Text (Open Office Calculator)

Описание: In this video I demonstrate how to solve a problem in Open Office Calculator... Here I show step by step how to transform date text such as '21 March 2022' to date formatted text in the more flexible form '21/03/2022'. I decided to make this video, as I was struggling to solve this problem myself a few days ago, and thought it might be useful to others.

If you'd like to watch more maths related content, make sure you're subscribed to my channel.

Thanks for watching!

To follow me on social media, visit:

  / tiago_hands  
  / tiago_hands  

ENTIRE OPEN OFFICE CALCULATOR 4 PLAYLIST:

Link:    • Open Office 4 Tutorials [Spreadsheets]  

1. How to get numbers going down a column in multiples (Open Office 4)    • How to get numbers going down a column in ...  

2. How to sum up columns of numbers (with a currency) using Open Office 4    • How to sum up columns of numbers (with a c...  

3. How to get the percentages of values in a column, relative to one specific value (Open Office 4)    • How to get the percentages of values in a ...  

4. How to save and password protect your spreadsheet file (Open Office 4)    • How to save and password protect your spre...  

5. How to increase the size of many cells with overlapping text - all at once (Open Office 4)    • How to increase the size of many cells wit...  

6. How to sum up values associated with multiple names - all at once [SUMIF] (Open Office 4)    • How to sum up values associated with multi...  

7. How to sum up all the values associated with a specific name in a list (Open Office 4)    • How to sum up all the values associated wi...  

8. How to compare two lists on a spreadsheet [ISNUMBER, MATCH, TRUE OR FALSE] :: Open Office 4
   • How to compare two lists on a spreadsheet ...  

9. How to Create a Line Chart using Open Office 4 [Applied Statistics]    • How to Create a Line Chart using Open Offi...  

10. How to Create a Pie Chart using Open Office 4 [Applied Statistics]    • How to Create a Pie Chart using Open Offic...  

11. How to Sum up Cells from Different Sheets, Open Office [Spreadsheet Tricks]    • How to Sum up Cells from Different Sheets,...  

12. How to Make Grid Lines Invisible on Open Office [Free Spreadsheet Tutorial]    • How to Make Grid Lines Invisible on Open O...  

13. How to make Days and Dates go down a Column in Corresponding Order [Open Office Spreadsheets]
   • How to make Days and Dates go down a Colum...  

14. How to Calculate Percentage Changes using Open Office and Format in Colour (Conditional Formatting)
   • How to Calculate Percentage Changes using ...  

15. How to Quickly Create a Table with the Powers of Ten In Digits (Open Office Spreadsheets)    • How to Quickly Create a Table with the Pow...  

16. How to automatically mimic data from the column on one sheet to another sheet (Open Office)    • How to automatically mimic data from the c...  

17. Find amount of days that have passed between two dates - Open Office Calculator    • Find amount of days that have passed betwe...  

18. Conditional formatting: How to highlight specific text in a list (Open Office Calculator)    • Conditional formatting: How to highlight s...  

19. How to graph in 2 dimensions using Open Office Calculator [Example: y=x^2]    • How to graph in 2 dimensions using Open Of...  

20. How to do basic probabilities using Open Office Calculator [Example: Dice Roll]    • How to do basic probabilities using Open O...  

21. How to Transform Date Text to Date Formatted Text (Open Office Calculator)    • How to Transform Date Text to Date Formatt...  

22. Open Office Calculator 4 Tricks: How to Create New Lines within 1 Cell [CTRL+Enter]    • Open Office Calculator 4 Tricks: How to Cr...  

23. Open Office Calculator 4, Productivity: How to Apply and Use The Auto-Filter Feature    • Open Office Calculator 4, Productivity: Ho...  

24. Open Office 4 Calculator: Bold, Italic and Underline Keyboard Tricks to Save Time & Energy    • Open Office 4 Calculator: Bold, Italic and...  

25. Open Office 4 Calculator: How to Create Vertical and Horizontal Pivot Tables Instantly * Save Time
   • Open Office 4 Calculator: How to Create Ve...  

26. Open Office 4 Calculator: How to Wrap Your Text and Keep it Within Boundaries    • Open Office 4 Calculator: How to Wrap Your...