CODEWITHSUNDEEP
excelscientific-notation
Vishal R
Vishal R

Reputation: 1379

Microsoft Excel converts all numbers to Scientific Notations

Whenever I enter any integer in Excel it converts it to Scientific notation, Below is the result when I add 1, 2, 3:

enter image description here

How do I stop this? If I type 1. it considers it as integer.

Upvotes: 0

Views: 51

Answers (1)

Vishal R
Vishal R

Reputation: 1379

Resolved. Found the culprit.
The following setting was enabled somehow in File-> Options-> Advanced
and set to 20 decimal places.

enter image description here

Upvotes: 1

Related Questions