Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]() "Dave O" wrote in message oups.com... The first time I tried this I formatted a cell as custom, with "00000" (including quotes) in the Type field. Then I tried it without quotes and got the desired results. Why quotes? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to add a letter in front of each number in a cell | Excel Discussion (Misc queries) | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
making a number be text | Excel Worksheet Functions | |||
how do i get excel to NOT take zero's of the front of a number | Excel Discussion (Misc queries) |