New
#1
cell formatting in excel 2010
I need some help in cell formatting using excel 2010. Wen I copy a 12 digit number (i.e. 163589453609), and paste it in a cell, this is what is shown 1.5358E+11. To get the actual number to be shown, I have to to the function cell and put a ' in front of the number to get the full 12 digit number to be shown in the original cell. I tried what I think are all the choices in the format cell drop down menus. Any ideas? Thanks
Mark