Excel Magic Trick 1069: Displaying Decimal and Fractional Inches in Excel: 1/3' or 2.5' or 2 1/3'

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

Back Slash in Custom Number Formatting to Insert a character into the Custom Number Formatting.
See how to use Custom Number Formatting to display inches in Excel:
1. =1/3 with CNF: ?/?\" shows: 1/3"
2. =1/3 with CNF: ?/?" ' ' " shows: 1/3"
3. =1/3 with CNF: ?/?" in" shows: 1/3 in
4. =2.5 with CNF: 0.0\" shows: 2.5"
5. =2+1/3 with CNF: # ?/?\" shows: 2 1/3"
6. =12/64 with CNF: ??/??\" shows: 3/16"
7. =12/64 with CNF: ??/64\" shows: 12/64"
  1. excelisfun
  2. Excel 2013
  3. Excel 2003
  4. Excel 2007
  5. Excel 2010
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:04:06

Excel Magic Trick 1069: Displaying Decimal and Fractional Inches in Excel: 1/3' or 2.5' or...

Excel Magic Trick 0:04:06

Excel Magic Trick 1069 Displaying Decimal and Fractional Inches in Excel 13 or 2 5 or 2 13

Excel Magic Trick 0:03:56

Excel Magic Trick 1067: Displaying Fractional Percent in Excel like: 33 1/3 % or 3/10%

Excel Magic Trick 0:03:15

Excel Magic Trick 1070: 4 'Yes' Votes Out of 12 as '4/12' with COUNTIF and COUNT...

Excel Magic Trick 0:03:37

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

Excel Magic Trick 0:21:59

Excel Magic Trick 1071: Dynamic Range Based on Product and Start & End Month: OFFSET, INDEX or A...

Excel Magic Trick 0:04:31

Excel Magic Trick 1213: Fraction Number Formatting & Making Sure the Correct Number Is Displayed

Excel Magic Trick 0:06:07

Excel Magic Trick 1414: Power Query Text.PadStart Function to Correctly Format Account Numbers

INDEX & RANDARRAY 0:00:58

INDEX & RANDARRAY Functions to Create Table of Data. # Short Excel Magic Trick 03

Excel1 1 0:05:37

Excel1 1

Hide digits in 0:01:00

Hide digits in Mobile Number | Secret Excel Trick #shorts #new #viral #tricks

Number of fridays 0:02:27

Number of fridays beetween two dates | Excel Tips #21

Trick_147👍Get Current Activated 0:00:54

Trick_147👍Get Current Activated Sheet Name By Using Single Function |👍#Excel #Expert

convert meter to 0:00:50

convert meter to inches with Short formula | Excel Secrets

How to Convert 0:00:31

How to Convert inch to Feet #exceltips #exceltutorial #excel

Αύξων αριθμός ανάμεσα 0:05:40

Αύξων αριθμός ανάμεσα στο κείμενο κελιών στο Excel π.χ. α1χ, α2χ, α3χ με την λαβή συμπλήρωσης....

Convert number in 0:00:31

Convert number in fraction in excel #vikominstitute #excel #fraction

Excel Trick || 0:00:30

Excel Trick || Decimal to Fraction || Step Up Classes ||

Excel Magic Tick 0:13:05

Excel Magic Tick 1458: Lookup Price in Multiple Tables: VLOOKUP, INDIRECT & Defined Names

Excel New 2023 0:00:56

Excel New 2023 / Excel Tips trick /Decimal problems solution #excel tips #trending

#Shorts Show in 0:00:18

#Shorts Show in Fraction Not in Decimal #Excel #Exceltutorial #Exceltrick #Fraction

How to Show 0:04:00

How to Show Double Quotes Using Excel Formulas

Display Data Visually 0:05:00

Display Data Visually in Excel with Data Bars and Color Scales

Excel tip how 0:00:14

Excel tip how to convert decimal to fractions

Комментарии
Автор

Excel Magic Trick 1069: Displaying Decimal and Fractional Inches in Excel: 1/3" or 2.5" or 2 1/3" 

excelisfun
Автор

ExcellsFun I appreciate all of your videos and have found them very helpful.  I thought I knew a lot, but I learn something new every day from you.  My question is I'm wanting to take a decimal and convert it to feet inches, but I want to format it to go to the nearest fraction, but not exceeding 16ths.  Here is what I'm using, but having trouble with the text formatting.  working Number 318.75Next Cell   318.75/12  =  26.5625Result  26.5625 (in Cell I31)Formula to convert =INT(I31)&"' "&TEXT(12*(I31)), "#-#/##")&CAR(34)Result  26' 6-3/4"However a number like 163.465 will give me a result of 13' 7-20/43", and I would prefer it rounding down to nearest 16th (16' 7-7/16").

Quickliftsystems
Автор

Hi Dear, Thanks for the video. I have a quarry. If I want to make .6=1, it increases like .1, .2, .3, .4, .5 when it's .6 it makes 1.0. like and next Stape is 2 in one cell? how can I make it?

AaAbid-sprd
Автор

12'5"*10'4" multiply send formula plz sir

amirsiddiqui
Автор

fyi, 1/3" is not a correct measurement number. it should have denominator in 2, 4, 8, 16, 32 etc

td