Excel Magic Trick 1216: Fraction Number Formatting To Show Only Significant Digits, Like: ####/####

preview_player
Показать описание

Learn how to apply Fraction Number Formatting To Show Only Significant Digits, Like: ####/####. Compare using ???? and #### for Custom Number Formatting in Excel. Thanks to Online Excel Teammates: Awafi and Doug Stevens at YouTube.
Рекомендации по теме
Комментарии
Автор

Excel Magic Trick 1216: Fraction Number Formatting To Show Only Significant Digits, Like: ####/####

Learn how to apply Fraction Number Formatting To Show Only Significant Digits, Like: ####/####.
Compare using ???? and #### for Custom Number Formatting in Excel.
Thanks to Online Excel Teammates: Awafi and Doug Stevens at YouTube.

excelisfun
Автор

Great!
I liked the format for mixed number!

pmsocho
Автор

Great tip. I like the ## tags better actually
Thanks Mike

krn
Автор

Would the indenting also work when using the TEXT formula? Like =TEXT(A5, B5) would show "3/25 ".

maartentbm
Автор

u guys make it so easy, but can u please help me with a mailing list i have. i want to see if there is duplicate addresses in the list then separates the non duplicate in another row please please help

LGreen-zgoc