| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
zero in front of a number
I am trying to put a zero at the front of a number in a cell in excel, 03507
but it keeps coming out as 3507. I have tried to custom 00000 but then it just goes to 00000 in the cell, can anybody please help getting fedup with it now. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
"Sandra W via OfficeKB.com" wrote in message ... I am trying to put a zero at the front of a number in a cell in excel, 03507 but it keeps coming out as 3507. I have tried to custom 00000 but then it just goes to 00000 in the cell, can anybody please help getting fedup with it now. What do you mean by "it goes to 00000 in the cell"? I formatted a cell that way and it only shows five zeros if I enter a zero. If blank, it shows nothing. |
|
#4
|
|||
|
|||
|
"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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
