21 August 2014
Agarwal Sir, that converts number into text and make computations impossible. that is why you need to format it as a number instead of text
22 August 2014
in "'" option, you will have to manually put ' in every cell. In format format option, the formatting can be applied to whole of the workbook, sheet, particular row or column in a second. So it saves time.