Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Overlapping Cells
When I enter a long number, it overlaps into the next cell. However, I do
not get the # sign. Instead, a type of formula appears. For example if I entered 22222222222222 (14 2's), what appears is 2.22222E+14. Why does it do this? Or, if I select that column, right click then choose Format Cells and change to Number Format, the cell width automatically adjusts itself. Is there somewhere in Excel Options I can change this? What am I doing wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bar Chart overlapping | Charts and Charting in Excel | |||
overlapping of text | Excel Worksheet Functions | |||
Overlapping Arrays? | Excel Discussion (Misc queries) | |||
Overlapping Charts | Charts and Charting in Excel | |||
Overlapping Pie Charts | Charts and Charting in Excel |