List/Grid Tag Archives: microsoft excel

How to Add Zero Before Number in Microsoft Excel: Put your field into editable mode in which you want to add zero before number. Before start typing type single quote ( ‘ ) then enter anything you want to enter. Data will be in exact format as you entered. After accepting single quote will disappear. A green marker on the upper left corner shows the presence of quote. Enjoy…