Is it possible to define a custom number format to display lengths such as 6' 2"? I found a custom function on this site that allows me to display decimals in that manner, but I'd prefer to eliminate the functions, as I'm dealing with several thousand lines. Simple text formatting will give me the display I want, but I lose my numerical values (6' 10" sorts as less than 6' 2").
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Feet-inches number format
- Thread starter jlarson
- Start date
lenze
Legend
- Joined
- Feb 18, 2002
- Messages
- 13,690
Use custom format and enter
0"Ft".00"in."
This will allow you to enter feet and inches, but you will have to enter less than 10 inches with a leading zero. 10.06 for 10 ft 6 inches, 5.11 for 5 ft 11 inches. This will allow proper sorting. If you want the display to be 5'.06" then substitute a ' inside the double quotes for ft and two single ' inside the double quotes for in. You might also look at the DOLLARDE and DOLLARFR functions to assist in using your entires in calcualtion.
This message was edited by lenze on 2002-05-03 10:13
0"Ft".00"in."
This will allow you to enter feet and inches, but you will have to enter less than 10 inches with a leading zero. 10.06 for 10 ft 6 inches, 5.11 for 5 ft 11 inches. This will allow proper sorting. If you want the display to be 5'.06" then substitute a ' inside the double quotes for ft and two single ' inside the double quotes for in. You might also look at the DOLLARDE and DOLLARFR functions to assist in using your entires in calcualtion.
This message was edited by lenze on 2002-05-03 10:13
Upvote
0
Similar threads
- Solved
