Recently I came to know about a site TIO.run . It has almost 97 languages compilers which help you to code and execute. I find it very cool since you don't need to install anythin to try out in your computer , instead write and compile it online. Try tio.run
Today I got a requirement to format the number in excel cell - to left pad number with zeros.i find the following function very useful to do it. In case one to make the number left padded with "0" s give the formula =TEXT(A1,"0000") In case two even more enhanced form to make it left padded with "0" and add two decimal places give the formula as =TEXT(A2,"0000.00")
Comments
Post a Comment