slecting leading number from a string

[AbdulBasit]

below are sample of sales 

123

234

123

456

567

i need a formula to extract the leading digit from the numbers. 

Thank u every one.

[atcodedog05 · Accepted solution]

Hi @AbdulBasit 

Here is the formula

Left(Tostring([Field]),1)

Field is the column name.

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[AbdulBasit]

thanku very much. How do i mark your answer as solution i do not see any option over here .

[atcodedog05]

Hi @AbdulBasit 

You have posted the question in introduction channel. You need to post the question in main homepage for you to be able mark it as solution.

Anyways

Happy to help 🙂

Cheers and Happy Analysing 😀

[atcodedog05 · Accepted solution]

Hi @AbdulBasit 

Your post has been moved to discussion channel. 

Now you will be able to mark the solution🙂