1Tap Quick Bar is a notification customization app for Android. It helps to do most common tasks in a shorter time, such as change Wifi settings, bluetooth settings, quick call to your dearest ones etc
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