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
Bookmarks