Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

DannyNguyener

macrumors regular
Original poster
Mar 13, 2010
117
0
I am trying to entire a large number in a cell. 120,511,000,000 to be exact. When entered into a cell, 1.20511E11 is shown.

How can I adjust this to where it will not show up in scientific notation? Thanks!
 
first just select the cell you want to format. then click that little arrow that i circled in the image. in the dropdown, just select "numerical system" and you should be good to go. you can add decimal places also in that same menu.
 

Attachments

  • screenshot.png
    screenshot.png
    18.6 KB · Views: 98
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.