Nokia has officially announced to stop launching Symbian phone.So the count down of Symbian has started.Now the developers and consumers of Symbian has to switch to either Windows Phone 7 platform or Android.
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