Quote:
Originally Posted by CGM3
Set the cell's format to text (right click on the cell or cells, choose Format Cells, on the Number tab click the Text category and then the OK button.)
This means you won't be able to use the value of that number unless you convert it using VALUE(). Also, formulas don't work in text cells.
|
Thanks for your help. Please clarify the following:
"This means you won't be able to use the value of that number unless you convert it using VALUE(). Also, formulas don't work in text cells.[/quote]"