[Solved] When I enter a number and it converts to a formula result

[Donald]

I have a number, 184001524221, that must be entered in a column and when I do I always get the following result

[td width="133pt"]

1.84002E+11​

[/td]​

 

[shamimarita]

Hello Donald,

This happens because Excel formats the number in scientific notation, which is its default behavior for large numbers. To display the full number without scientific notation, you can follow the steps given below:

1. Select the cell or column.
2. Right-click and select Format Cells from the context menu.

3. In the Format Cells dialog box, choose the Number category.
4. Set the number of decimal places to 0 (if you don't need any decimals).
5. Click OK.


Now, it should be displayed in its full form, without scientific notation.