Excel Magic Trick 1423: Power Query Number.ToText Function to Format Numbers as Text

Download File:
Start File: https://excelisfun.net/files/EMT1423Start.xlsx
Finished File: https://excelisfun.net/files/EMT1423Finished.xlsx
Entire page with all Excel Files for All Videos: https://excelisfun.net/
Trick from pmsocho at YouTube. Here is the video he made on this topic: excel-711 - Tajemnica funkcji Number.ToText w Power Query https://www.youtube.com/watch?v=fPvKxxlF8LA&t=0s
Learn about the Power Query Function Number.ToText to use some Excel Custom Number Formatting and Power Query Custom Number Formatting to format numbers and convert then to text.
This video answers the question: Can we apply Excel Number Formatting in Power Query?
This trick comes from pmsocho at YouTube.

Видео Excel Magic Trick 1423: Power Query Number.ToText Function to Format Numbers as Text канала ExcelIsFun