Numeric Cell Value with text description
 

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!

Numeric Cell Value with text description
 

On Tue, 20 Jun 2006 17:11:02 -0700, Paco86
wrote:

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!

Select A1, then:

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

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


--ron

Numeric Cell Value with text description
 

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
--
paul

remove nospam for email addy!



"Ron Rosenfeld" wrote:

On Tue, 20 Jun 2006 17:11:02 -0700, Paco86
wrote:

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!

Select A1, then:

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

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


--ron