Display More Text In Cell Than is Typed In

[pwebley]

I would like to format a cell that shows more text than what is actually typed in. For instance, I want the cell to show "6 Months or Less" but the user only types in the "6." I know I can concatenate cells to do this but I would rather have the cell formatted to always show the "Months or Less" and then the user just changes the actual number. If they were to open the cell it would only contain the number but when they hit enter the full text displays "6 Months or Less." Is there any way of doing this?

 

[jeffreybrown]

Go to the cell >> Ctrl + 1 >> Number Tab >> Custom >> Enter 0" Months or Less"

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=414

 

[pwebley]

Thanks, works great!

 

[jeffreybrown]

Glad to hear it...you're welcome