TechRepublic|Forums|Software

Software

General discussion

  • Creator
    Topic
  • September 11, 2001 at 3:07 am #2345715

    Excel Formatting

    Locked

    by lf king · about 22 years, 7 months ago

    When I enter the following number 466240160492540 into a cell it converts it to 4.6624E+14. The only way I’ve gotten it to stay as entered is to insert a ‘ before the number.

    Totally Confused

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • September 11, 2001 at 3:26 am #3614685

      Excel Formatting

      by dklippert · about 22 years, 7 months ago

      In reply to Excel Formatting

      Either go to Format>Cells, or Right-click the cell(s) and choose Format.
      Change the formatting to Number with 0 decimal places.

      • September 11, 2001 at 3:44 am #3614682

        Excel Formatting

        by lf king · about 22 years, 7 months ago

        In reply to Excel Formatting

        Poster rated this answer

    • September 11, 2001 at 3:44 am #3614681

      Excel Formatting

      by lf king · about 22 years, 7 months ago

      In reply to Excel Formatting

      This question was closed by the author

  • Author
    Replies
Viewing 1 reply thread