Need help in Numbers/Excel

Discussion in 'Mac Apps and Mac App Store' started by DannyNguyener, Apr 26, 2011.

  1. DannyNguyener macrumors regular

    DannyNguyener

    Joined:
    Mar 13, 2010
    #1
    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!
     
  2. cas85 macrumors regular

    Joined:
    May 4, 2010
    #2
    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.
     

    Attached Files:

  3. DannyNguyener thread starter macrumors regular

    DannyNguyener

    Joined:
    Mar 13, 2010

Share This Page