EXCEL EXCEL ~~ Change the DATE format to TEXT format

We ran into problems when we are trying to upload data from Quadrate (Data Workbench) to SAP if there are columns that are showing the transaction date for each record, if we don't change the data type to TEXT, the upload will be failed.

I play and test a bit, summarize what I learned so far:

1. Add a comma sign in front of the date, however, it has a limitation, all the date must be the same in the column to take the max advantage of this skill

2. By using a TEXT formula, it can change the entire column but need an additional help column to paste the value back

3. By using the DATA function, TEXT to column

Work or life ~~ 55 Vogell Road ~~ Happy Valentine's Date!

💗

It was a big surprise when I arrived at my desk that morning. There are a handful of beautiful candies on my desk. They were placed nicely in a paper cup, with a little flag in the middle. The first thing jumped out of my mind was who is admiring me, although I am in my 40 and not so attractive, hopefully, he is a handsome guy. Soon I laughed at my self~~every one's desk has the same thing! And when I turned around, I saw that the reception lady Sheila, who was holding a food plate that full of these cups and smiling at me with a warm morning smile. After the morning hellos, I realized that these were from the community committee, simply to address their thankfulness to the employees who contributed to the charity events last year. 

Oh well, although it was not for me only, it gave me a whole good mood. In my eyes, everything looks PINK that day!

Work or life ~~ Insurance paid for family members is eligible medical expense

Read a Youtube post about medical expense claim for income tax return. From the post host Liu Jiang's wording, when we bought that private health insurance for our visiting parents, the fees can be claimed as a medical expense.

Surprise me and I spent the time researching the CRA website for the reference:

https://www.canada.ca/en/revenue-agency/services/tax/technical-information/income-tax/income-tax-folios-index/series-1-individuals/folio-1-health-medical/income-tax-folio-s1-f1-c1-medical-expense-tax-credit.html

EXCEL EXCEL ~~ Utilize Power Query to quickly resolve small problem

I agree you may want to take advantage of this tool to solve your work problems.

Such as this one. My coworker lady Sandy need to transfer a data in the format of .csv into Excel. I helped her to load the data via Power Query from the DATA tab. The job is done just in a minute!