How to add automatic text in a column after entering a number

[Adam H]

Hey guys,
I'm completely new to this site and quite frankly it is my first time joining a forum. I'm trying to set up an excel sheet where I can record the weights of an object. In the column I want to be able to enter the weight as a number, lets say 40, and have it return as 40 lbs. Is this possible? Thank you in advance!

 

[jeffreybrown]

Hello Adam & Welcome to the forum,

You can use a custom format...

Custom Format

• Right click cell (or Ctrl + 1)
• Format Cells
• Number
• Custom
• Type: 0" lbs."

 

[Adam H]

Thank you! It was really obvious in hindsight. (Keyword hindsight)