# showing decimal as 32nd

Page 1 of 1

## 1 Replies - 6071 Views - Last Post: 31 August 2012 - 03:52 PMRate Topic: //<![CDATA[ rating = new ipb.rating( 'topic_rate_', { url: 'http://www.dreamincode.net/forums/index.php?app=forums&module=ajax&section=topics&do=rateTopic&t=289506&amp;s=e6130a7c26df34f1d005b65bf68a3e88&md5check=' + ipb.vars['secure_hash'], cur_rating: 0, rated: 0, allow_rate: 0, multi_rate: 1, show_rate_text: true } ); //]]>

### #1 achavez

Reputation: 0
• Posts: 8
• Joined: 16-August 12

# showing decimal as 32nd

Posted 20 August 2012 - 08:27 AM

Hope to find some help!

A1 has 101.265625
In 32nd's this should be 101-084
in B1 is there a formula I can do to show 101-084?

This is the formula i am using to TRY to get 101-084

=SUBSTITUTE(DOLLARFR(A1, 32), ".", "-") HOWEVER, this returns 101-085 and not 101-084

Any help?
Thanks!
Is This A Good Question/Topic? 0

## Replies To: showing decimal as 32nd

### #2 BobRodes

• Lovable Curmudgeon

Reputation: 594
• Posts: 3,055
• Joined: 19-May 09

## Re: showing decimal as 32nd

Posted 31 August 2012 - 03:52 PM

You have a rounding error that isn't easy to solve. This formula seems to do the trick:
```=INT(DOLLARFR(B2,32)* 100)/100+DOLLARFR(MOD(B2,1/32),256)
```

where your input number is in cell B2.

The INT function strips off all but the first two decimals. DOLLARFR gets the .08 from this number. Then take the remainder of the input number divided by 1/32, and apply DOLLARFR to the result.