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

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

HomeOther ContentExcel Magic Trick 1423: Power Query Number.ToText Function to Format Numbers as Text
ChannelPublish DateThumbnail & View CountActions
Channel Avatar excelisfun2017-05-16 14:23:03 Thumbnail
28,321 Views
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.

Please take the opportunity to connect and share this video with your friends and family if you find it useful.