0

I am entering 1044372000263084 into a cell in Excel 2013. When I hit enter the cell is changing to 1.04437E + 15 . The bar above the table shows 104437200063080.

Why is it changing and how can I make it stop?

nixda
  • 27,634
user347013
  • 1

2 Answers2

0

Select the cells where you are going to input, hit Control + 1 to format cells, select "Number" under the Number tab (optionally, set Decimal places to zero), hit OK. Now, long numbers entered into the cells just formatted will appear without scientific notation.

D Schlachter
  • 2,058
0

Excel will treat the content aimed for a cell as TEXT,
if the data to go into that cell has a single quote as first character.
="The char: "&CHAR(39) in a cell will show that character.

=VALUE(ADDRESS) will allow you to use the number.

Hannu
  • 10,568