detriez
Board Regular
- Joined
- Sep 13, 2011
- Messages
- 193
- Office Version
- 365
- Platform
- Windows
My data has 8 digits some of which have a leading zero
I'm trying to Use the LEFT Function to get the first 6 digits including the leading zero when it exists (see below)
I can force it by adding an apostrophe when typing the values but, how can I do it for thousands of records?
I tried all of the formats and custom formats I could come up with to no avail
I'm trying to Use the LEFT Function to get the first 6 digits including the leading zero when it exists (see below)
I can force it by adding an apostrophe when typing the values but, how can I do it for thousands of records?
I tried all of the formats and custom formats I could come up with to no avail
097102 | 09710202 |
097199 | 09719900 |
097199 | 09719901 |
097199 | 09719902 |
101100 | 10110000 |
101101 | 10110100 |
101101 | 10110101 |
101101 | 10110102 |