Excel Magic Trick 1068: TEXT and FIXED functions for Formatting Numbers in Text Formulas




About this tutorial:

Video duration: 3:37
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm
See:
1. Learn about the TEXT and FIXED functions for Formatting Numbers in Text Formulas.
2. Learn how to use Custom Number Formatting in TEXT function.
3. Learn how to use FIXED rather than TEXT function when formatting numbers with comma separators.

Cool formula trick when Dates and Commas don’t show up properly (correctly) in text formulas.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

Your email address will not be published. Required fields are marked *