February 11, 2025
Excel Top Contributors:
Have a cell display decimals as lbs & oz
I am trying to find a way to format cells to show pounds and oz without using formulae. e.g. I want to be able to type in 151.25 and have it display as 151lbs 4oz. I currently have it showing 151 1/4lbs but I was just curious to know if it could be formatted to automatically show 4oz instead of 1/4lb. I know this is petty but then that's OCD for you!!
Steve
Report abuse
Thank you.
Reported content has been submitted
A custom number format of
0"lbs" ?/16"oz"
gets close but includes an unwanted "/16"
I can't think of anything better without using formulas
Report abuse
Thank you.
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.

cheers, teylyn
Community Moderator
www.teylyn.com
Report abuse
Thank you.
Reported content has been submitted
1 person found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Question Info
Last updated January 24, 2024 Views 742 Applies to: