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
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 6, 2019 at 5:29 | comment | added | teylyn |
or simpler: =LEFT(TEXT(A1,"0000"),2)
|
|
| Aug 6, 2019 at 5:03 | comment | added | Michael Frank | Nice, a much simpler formula than my quick example. +1 | |
| Aug 6, 2019 at 5:02 | history | edited | fixer1234 | CC BY-SA 4.0 |
added 84 characters in body
|
| Aug 6, 2019 at 4:53 | history | answered | fixer1234 | CC BY-SA 4.0 |