Numbers are overflowing to the cell in the next column

%3CLINGO-SUB%20id%3D%22lingo-sub-3190533%22%20slang%3D%22en-US%22%3ENumbers%20are%20overflowing%20to%20the%20cell%20in%20the%20next%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3190533%22%20slang%3D%22en-US%22%3E%3CP%3EAll%20of%20the%20sudden%2C%20when%20I%20am%20adding%20numbers%20to%20a%20cell%20it%20is%20spilling%20over%20to%20the%20cell%20in%20the%20next%20column.%3C%2FP%3E%3CP%3ECan%20you%20tell%20me%20how%20to%20keep%20all%20these%20numbers%20in%20the%20one%20cell%20as%20it%20originally%20did%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3190533%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3190597%22%20slang%3D%22en-US%22%3ERe%3A%20Numbers%20are%20overflowing%20to%20the%20cell%20in%20the%20next%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3190597%22%20slang%3D%22en-US%22%3EIf%20the%20size%20of%20the%20contents%20in%20a%20cell%20are%20too%20big%20to%20fit%20then%20they%20will%20either%20a)%20wrap%20to%20the%20next%20line%20(see%20home-%26gt%3Bwrap%20text)%2C%20b)%20overflow%20into%20the%20next%20cell%20(but%20only%20if%20that%20next%20cell%20is%20empty)%20or%20c)%20get%20clipped%20(if%20wrap%20text%20isn't%20on%20and%20the%20next%20cell%20isn't%20empty)%20If%20this%20isn't%20the%20issue%20you%20can%20get%20odd%20formatting%20issue%20when%20copy%20and%20paste%20from%20another%20document.%20Try%20clear%20formatting%20(home-%26gt%3BClear%20and%20in%20the%20drop%20down%20select%20clear%20formatting)%3C%2FLINGO-BODY%3E
Occasional Visitor

All of the sudden, when I am adding numbers to a cell it is spilling over to the cell in the next column.

Can you tell me how to keep all these numbers in the one cell as it originally did?

Thanks

1 Reply
If the size of the contents in a cell are too big to fit then they will either a) wrap to the next line (see home->wrap text), b) overflow into the next cell (but only if that next cell is empty) or c) get clipped (if wrap text isn't on and the next cell isn't empty) If this isn't the issue you can get odd formatting issue when copy and paste from another document. Try clear formatting (home->Clear and in the drop down select clear formatting)