Software

Ask something
Discussion Locked

Excel Formatting

0 helpful
3 replies

by lf king

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by dklippert

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

This discussion is closed to new replies.