Almost there!

The number in column "B" is how I need the number to appear, however the rounding is off.

Once the number behind the ( ' )goes over 32 I need the number to the left of the ( ') to increase by 1.

For example, using the sam numbers you used:

--A--- ---B----
1 953.78 955'04.0
2 651.28 651'28.0
3 123.59 124'27.0
4 347.24 347'24.0
5 6.71 8'07.0

In the formula you supplied I notice the 64, is that how this formula rounds? I need 32nd rounding after the (').


Quote Originally Posted by shg
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