Skip to main content
Anthony's user avatar
Anthony's user avatar
Anthony's user avatar
Anthony
  • Member for 3 years, 5 months
  • Last seen more than 3 years ago
awarded
comment
Google Sheets: How to format decimal as fraction in drop down list (data validation)
I'm Learning more each day. To address the extra spacing in my fractions (comment above), I learned that # ?/??? is an acceptable format string and will display the numerator w/o prepending any padding. 1 1/128 vs 1 1/128.
comment
Google Sheets: How to format decimal as fraction in drop down list (data validation)
I noticed mixed fractions tend to have additional spaces in their formatting: #[space][space]???/???[space] This becomes evident when passing the value to a function and converting to decimal. I stripped out the additional spaces using regex, but do you know why they appear and how to prevent it?
awarded
comment
revised
Loading…
revised
Google Sheets: How to format decimal as fraction in drop down list (data validation)
Edit to be more specific in the question I was asking
Loading…
Loading…
awarded
revised
Loading…
awarded
Loading…