Question

The data is treated as text and displayed in the same form as it has been entered, when we add _________before the number or data​

Answer 1

Answer:

If Microsoft Excel displays ##### in a cell after you apply number formatting to it, the cell probably isn't wide enough to display the data. To expand the column width, double-click the right boundary of the column that contains the cells with the ##### error. This automatically resizes the column to fit the number.