Single character sixteenths of an inch

palsmith

New Member
Joined
Nov 28, 2024
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hello,
Would anyone know of a source of single-character "sixteenths of an inch" vice the four-character "1/16"? it is fairly easy to find these up to eighth of an inch such as: ⅛ ¼ ⅓ ⅜½ ⅝ ⅔ ¾ ⅞. These single-characters help in limited field areas such as file names. Thank you.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Hello Cubist,
Thanks for the response. This site still creates a 4-digit "1/16". I need to save space at times and am looking for single digits such as: "⅛ ¼ ⅓ ⅜½ ⅝ ⅔ ¾ ⅞". If you double-click or swipe each of these with your mouse, you'll see they are single digit characters vice 3-digits. The sixteenths adds yet one more digit (and space). Thanks again.
 
Upvote 0
Initially, I thought the link provided a single character but I was wrong. From my search, I don't believe there's a single UNICODE for 1/16. I've only seen people concatenate to create the fraction.
 
Upvote 0
@Jaafar Tribak
It's not length 1 when paste into Excel.
Book1
AB
1¹⁄₁₆4
Sheet5
Cell Formulas
RangeFormula
B1B1=LEN(A1)
 
Upvote 0
@Jaafar Tribak
It's not length 1 when paste into Excel.
Book1
AB
1¹⁄₁₆4
Sheet5
Cell Formulas
RangeFormula
B1B1=LEN(A1)
You are correct. I didn't check properly.
There are free websites\softwares for creating your own hand drawn fonts but they are not easy to use, plus they should be distributed along the workbook for other users or programmatically using the AddFontResource api after extracting the font file bytes. Too much effort, in my opinion :(
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,178
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top