jgthtrotih
Well-known Member
- Joined
- Aug 28, 2009
- Messages
- 568
- Office Version
- 365
- Platform
- Windows
- Mobile
Hey All
i need a little help with leading zeros in excel i want a complete 3 digit number as shown blow (first chart) i used the " ' " mark to get the zeros in..i want the second chart to look the same with the zeros...
Chart 1: Examples and what I'm trying to get Achieve.
Chart 2: My actual data set.
Have Any Questions Let Me Know!
Using Excel 2003!
Thanks!
i need a little help with leading zeros in excel i want a complete 3 digit number as shown blow (first chart) i used the " ' " mark to get the zeros in..i want the second chart to look the same with the zeros...
Chart 1: Examples and what I'm trying to get Achieve.
Chart 2: My actual data set.
Excel Workbook | ||||
---|---|---|---|---|
E | F | |||
28 | RANDBETWEEN("000",999) | |||
29 | ||||
30 | ||||
31 | 356 | 356 | ||
32 | 454 | 454 | ||
33 | 48 | 048 | ||
34 | 367 | 367 | ||
35 | 785 | 785 | ||
36 | 46 | 046 | ||
37 | 856 | 856 | ||
38 | 986 | 986 | ||
39 | 46 | 046 | ||
40 | 85 | 085 | ||
41 | 8 | 008 | ||
Sheet |
Have Any Questions Let Me Know!
Using Excel 2003!
Thanks!