Timeline for How do I get the =LEFT function in excel, to also take the number zero as the first number?
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 29, 2019 at 8:46 | audit | First posts | |||
| Aug 29, 2019 at 8:47 | |||||
| Aug 13, 2019 at 8:57 | audit | First posts | |||
| Aug 13, 2019 at 8:58 | |||||
| Aug 12, 2019 at 5:36 | audit | First posts | |||
| Aug 12, 2019 at 5:36 | |||||
| Aug 8, 2019 at 12:27 | comment | added | MSalters | Int he same category: phone numbers aren't numbers either. | |
| Aug 8, 2019 at 0:16 | comment | added | teylyn | my approach works with strings as well as with numbers. I updated my answer with a screenshot. | |
| Aug 7, 2019 at 16:59 | comment | added | Monty Harder | @Falco Indeed, it's possible that at some point in the future, a "room number" of "1214A" will exist, and treating what is fundamentally a string as if it were a number will fail. | |
| Aug 7, 2019 at 15:54 | comment | added | Chronocidal |
This is also the QUOTIENT function: =QUOTIENT(A1,100)
|
|
| Aug 7, 2019 at 14:13 | comment | added | Falco | Good answer. - I would argue that the "Room numbers" are not really numbers, but more room-identifiers and type text is appropriate. My experience as an API developer has lead me to follow this rule of thumb: "If it doesn't make sense to add or multiply it, it should probably be saved as text rather than a number" - even more true for combined keys where certain "digits" have meaning. | |
| Aug 6, 2019 at 10:47 | history | edited | Máté Juhász | CC BY-SA 4.0 |
added 1 character in body
|
| Aug 6, 2019 at 8:26 | history | edited | Máté Juhász | CC BY-SA 4.0 |
added 245 characters in body
|
| Aug 6, 2019 at 5:44 | history | answered | Máté Juhász | CC BY-SA 4.0 |