Use of zero with multiple number
Closed
Arshad
-
17 Jun 2009 à 22:18
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 18 Jun 2009 à 05:42
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 18 Jun 2009 à 05:42
Related:
- Use of zero with multiple number
- Mpc hc multiple instances - Guide
- Split excel sheet into multiple files - Guide
- How to delete multiple files on mac - Guide
- Excel multiple lines in one cell - Guide
- How to consolidate data in excel from multiple worksheets - Excel Forum
1 response
mubashir aziz
Posts
190
Registration date
Sunday 12 April 2009
Status
Member
Last seen
16 February 2010
166
18 Jun 2009 à 05:42
18 Jun 2009 à 05:42
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 .....
