There are already good answeranswers available to your question, but Ifif you want to make this work with the same formula you had used initially:
=LEFT(A1,2)
Thenthen just prefix ' (Singlesingle quote before the number) See.
See the below screenshot for your reference
ie.eg., instead of just 0403, make it as '0403 and thethen apply the same formula.
Screenshot for reference below
Add prefix before the number:
Works with the same formula:
There are already good answer available to your question, but If you want to make this work with the same formula you had used initially
=LEFT(A1,2)
Then just prefix ' (Single quote before the number) See the below screenshot for your reference
i.e instead of just 0403, make it as '0403 and the apply the same formula
Screenshot for reference below
Add prefix before the number:
Works with the same formula:
There are already good answers available to your question, but if you want to make this work with the same formula you had used initially:
=LEFT(A1,2)
then just prefix ' (single quote before the number).
See the below screenshot for your reference
e.g., instead of just 0403, make it '0403 and then apply the same formula.
Screenshot for reference below
Add prefix before the number:
Works with the same formula:
There are already good answer available to your question, but If you want to make this work with the same formula you had used initially
=LEFT(A1,2)
Then just prefix '' (Single quote before the number) See the below screenshot for your reference
i.e instead of just 04030403, make it as '0403'0403 and the apply the same formula
Screenshot for reference below
Add prefix before the number (Refer the image below):
Works with the same formula. (Refer the image below):
There are already good answer available to your question, but If you want to make this work with the same formula you had used initially
=LEFT(A1,2)
Then just prefix ' (Single quote before the number) See the below screenshot for your reference
i.e instead of just 0403, make it as '0403 and the apply the same formula
Screenshot for reference below
Add prefix before the number (Refer the image below)
Works with the same formula. (Refer the image below)
There are already good answer available to your question, but If you want to make this work with the same formula you had used initially
=LEFT(A1,2)
Then just prefix ' (Single quote before the number) See the below screenshot for your reference
i.e instead of just 0403, make it as '0403 and the apply the same formula
Screenshot for reference below
Add prefix before the number:
Works with the same formula:
