|
|
#2
06-07-2012, 01:07 PM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to write the degree, minute second format in excel
|
Jamal NUMAN | Excel | 12 | 07-09-2018 11:44 PM |
| how to write G1 in terms of B1+value in the cell 5 columns away (which is G1 itself)) | Sunny | Excel | 3 | 04-20-2012 12:32 AM |
| Own starting page number when printing handouts | ffmarais | PowerPoint | 1 | 06-27-2011 12:54 AM |
|
How can I write the following (whole) formula in a single cell?
|
Learner7 | Excel | 1 | 07-19-2010 10:06 AM |
| How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
Windows XP 
Office 2007
Threaded Mode