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
Related:
- Use of zero with multiple number
- Mpc hc multiple instances - Guide
- How to make multiple selections in photoshop - Guide
- How to rotate multiple pictures at once windows 10 - Guide
- Allow multiple downloads chrome - Guide
- How to put multiple watermarks on a word document - 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 .....
