In ExcelSheet

While we are working in MS Excel Worksheet suddenly we may get #### in cells. We have not typed these characters but it appears in screen suddenly.And sometimes we may get 2E+15 in cells of Excel Worksheet.Let us see the reasons for the cell based errors below

Why #### ?

Whenever you are giving a number(very large number) in cell, if cells in Excel WorkSheet cannot able to hold the number then it may print these characters in cells.

Thus cells here are not able to hold such large numbers.Thus it prints #### characters in the user specified cells

Why 2E+15 ?

This is scientific notation of number that the user has specified.If the cell size is not enough then large numbers(to some limit) are printed in the scientific notations. If cell formatting is not done, then also this notation is displayed.

If the cell formatting is done in best way then proper number representation is obtained(no other number notations are obtained). There are some solutions for cell formatting which are as follows:

First Solution is by giving each cell bigger size. Thus if size is large, then numbers are displayed properly(thus column size is expanded here).

Secondly the cells are aligned according to AutoFit option. AutoFit adjusts the cells and entire numbers are displayed correctly without any flaws.

We must enable the AutoFit Option. Thus we must select format menu -> Column Option. In that "AutoFit Selecion" must be enabled for proper display of large numbers.