Numeric Cell Value with text description

P

Paco86

Hi, I wanted to know if it was possible to give a cell a numeric value but
also have a text description within that same cell. for example: cell A1 = 1
:Loan Count I want cell one to be able to be multiplied but when I click
on it, it will aslo display ":Loan Count". Thanks!
 
R

Ron Rosenfeld

Hi, I wanted to know if it was possible to give a cell a numeric value but
also have a text description within that same cell. for example: cell A1 = 1
:Loan Count I want cell one to be able to be multiplied but when I click
on it, it will aslo display ":Loan Count". Thanks!
Click to expand...

Select A1, then:

Format/Cells/Number/Custom Type: 0":Loan Count"

Type a 1 into A1 and it should display 1:Loan Count


--ron
 
P

paul

you can also use a comment that will show as an adjacent "post it" note that
says Loan Count or a data validation input message that says Loan Count
 
Top