Excel automatically convert number that is longer than 11 digits to scientific notation which can be frustrating. If you wish to get it back to normal number you could use the following method:

1. Highlight cells that need to convert to normal no.
2. Go to “Format Cells” >> “Number” >> “Custom” and at the “Type:” enter the value “0”

 

Difficulty level: Easy
Recurring Risk: No

 Want us to do this for you? It takes about 1 hour depending on the size of site.
Skill level required – Expert level
Our rate is $20 per hour ( min. 2 hours)
Call us at: +65 6511 4585 (Office hours)
Message us at: +65 8263 1460 (24 hours)
Email us at: [email protected]
Visit our website at: www.dyontech.com