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

Подписаться 1 млн

Просмотров 20 тыс.

50% 1

Download Excel Start File: people.highline.edu/mgirvin/Y...
Download Excel File: people.highline.edu/mgirvin/Ex...
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"

Опубликовано:

14 фев 2014

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 13

@pedrorivera1892 Месяц назад

AMAZING VIDEO, THANK YOU!

@excelisfun Месяц назад

You are welcome!!

@ExcelVbaIsFun 10 лет назад

Thanks, ExcelIsFun!

@notesfromleisa-land 2 года назад

Excellent!!!

@pmsocho 10 лет назад

Hard-coding denominator is great!

@excelisfun 10 лет назад

Glad you liked it!

@excelisfun 10 лет назад

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

@venkat6333 4 года назад

How to convert decimal into feet and inches. Ex:- 6'1"+6"+6" actually it is 7'1" but in Excel it's taking calculation as 10 count so it is 7.3 showing in Excel. I was entered like 6.1+.6+.6 =7.3 it's showing in Excel.

@AaAbid-sp5rd 2 года назад

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 1.1,1.2,.................1.5 and next Stape is 2 in one cell? how can I make it?

@Quickliftsystems 9 лет назад

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").