[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 446
  • Last Modified:

Revising a formula to convert a number in decimal format to a particular text format

A while ago I requested a formula to convert a number in decimal format to a text format using a ^ to separate the decimal portion of the number and convert it to 32nds.  I was given the formula below, which seemed to work fine:

=SUBSTITUTE(TEXT(ROUND(C3*32,0)/32,"0^0/32"),"/32","")

Now I need a (hopefully) small modification.  The formula above converts a number like 123.125 into the following text: 123^4, which equates to 123 and 4/32.  I now need it to appear as 123^04.  In otherwords, whenever the numerator of the fraction in 32nds is less than 10 it needs to have a zero in front of it.  For example, 123^1 would be 123^01, 123^7 would be 123^07 and 123^9 would become 123^09.

Can anyone adjust the formula for me?
0
pwflexner
Asked:
pwflexner
1 Solution
 
SteveCommented:
I think this will do it...

=SUBSTITUTE(TEXT(ROUND(C3*32,0)/32,"0^00/32"),"/32","")
0
 
pwflexnerAuthor Commented:
Thanks!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now