Results 1 to 13 of 13

help with 32nd rounding

Threaded View

novice2430 help with 32nd rounding 06-24-2008, 05:48 PM
mudraker novice2430 Welcome to... 06-24-2008, 08:44 PM
novice2430 Anyone have an answer? 06-27-2008, 12:56 PM
TheNorm I don't understand what you... 06-27-2008, 01:13 PM
novice2430 Sorry for not being clear. ... 06-29-2008, 11:58 AM
shg You can't do it with... 06-29-2008, 01:19 PM
novice2430 Almost there! The number... 06-29-2008, 04:34 PM
daddylonglegs Try ... 06-29-2008, 05:01 PM
novice2430 one last question, is it... 06-29-2008, 05:24 PM
daddylonglegs To do that you'd need to use... 06-29-2008, 05:28 PM
shg For whatever reason, I... 06-29-2008, 05:34 PM
shg You could format the cell as... 06-29-2008, 05:37 PM
novice2430 Oh okay, thanks for all the... 06-29-2008, 05:44 PM
  1. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    You can't do it with formatting, but you can use a formula that displays a number entered in another cell in that fashion:

    =INT(A1) & "'" & TEXT( ROUND( (A1 - INT(A1)) * 64, 0) / 2, "00.0")

    For example,
          --A--- ---B----
      1   953.78 953'25.0
      2   651.28 651'09.0
      3   123.59 123'19.0
      4   347.24 347'07.5
      5     6.71   6'22.5
    Last edited by shg; 06-29-2008 at 01:45 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1