xeven_
Active Member
- Joined
- Jan 20, 2012
- Messages
- 302
I want to divide a long string/column of large numbers by 10. For example 280875008 is in E1. When I put =10/E1 it is giving me 3.56E-08. I do not want the E-08. When I go to format cells and change it from general to number it is turning my values into zeros, which I also do not want. Is there a way yo make it stay as a normal number like 3.56 without all the drama. I am using excel 2016.
Thanks in advance
Thanks in advance
Last edited: