|
|
#3
07-22-2012, 09:32 PM
|
|||
|
|||
Actually, you can format the cell as a number, and still keep the leading 0. Custom format the cell with "000", this way, 50 will be displayed as 050, and 9 will be displayed as 009. Or, custom format with "0########", with as many "#" you need, and you will have only one zero before your number. (as long as the number of characters of the number is smaller than the number of characters in the custom format)
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I delete the content of a cell in column if the cell value is more than 1000? | Learner7 | Excel | 2 | 06-27-2011 05:44 AM |
 Enter + Alt + Enter is not working inside the text box! why????
|
Jamal NUMAN | Word | 3 | 04-17-2011 05:35 PM |
| How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
| How can I make a cell color RED under the Today's date cell? | Learner7 | Excel | 2 | 07-08-2010 12:52 AM |
| Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
Windows Vista 
Office 2010 32bit
Threaded Mode