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. |
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) |