Use of zero with multiple number
Closed
Arshad
-
Jun 17, 2009 at 10:18 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 18, 2009 at 05:42 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 18, 2009 at 05:42 AM
Hello,
I am Arshad from Jamshedpur. my question is that when we enter zero (0) in a cell. That time cell accept zero but when we enter zero (0) with multiple number for e.g, 01234. the cell missed out zero and take only 1234. explain for this what we will do for which the cell take all the number. please give my feedback as soon as possible
I am Arshad from Jamshedpur. my question is that when we enter zero (0) in a cell. That time cell accept zero but when we enter zero (0) with multiple number for e.g, 01234. the cell missed out zero and take only 1234. explain for this what we will do for which the cell take all the number. please give my feedback as soon as possible
Related:
- Use of zero with multiple number
- How to lasso multiple objects in photoshop - Guide
- Allow multiple downloads chrome - Guide
- How to delete multiple files on mac - Guide
- How to rotate multiple pictures at once windows 10 - Guide
- How to open multiple media player windows - Guide
1 response
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
Jun 18, 2009 at 05:42 AM
Jun 18, 2009 at 05:42 AM
Actually it depends on your needs suppose you have 5 digit employees number so you want that if you enter 1 then it should be 0001 and if 555 then 00555 and if 4444 then 04444 but if enter 66666 (five figures) then only show 6666 .....
Just select the cell where you want to apply now go in Format> Cell > Number > Custom > in Type write 00000 five zero so above rule will apply ....... if you need any thing else do let me know ....... as you know by default if you put 0 infront of any numeric then there will be no impact on it so that why by default it convert it in a number without 0 ......
but if you make that cell as text Format> Cell > Number > Text ... then you can enter 01234 but it will enter as text and no calculation will be done on it .....
Just select the cell where you want to apply now go in Format> Cell > Number > Custom > in Type write 00000 five zero so above rule will apply ....... if you need any thing else do let me know ....... as you know by default if you put 0 infront of any numeric then there will be no impact on it so that why by default it convert it in a number without 0 ......
but if you make that cell as text Format> Cell > Number > Text ... then you can enter 01234 but it will enter as text and no calculation will be done on it .....
