Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fitting text into a cell problem. Please help!
Hi a colleague of mine is trying to fit a lot of text into a cell however
once he reaches acertain point the text dissapears from the cell and is replaced with ####. The text is still visable within the formula bar. I have tried increasing the size of the column and row and selected the autofit function, wrapped text etc. but it still keeps happening. I have no idea where to look next. Any advice?? -- Nat |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fitting text into a cell problem. Please help!
Tell him to format the cell as General (or anything but text).
Natty wrote: Hi a colleague of mine is trying to fit a lot of text into a cell however once he reaches acertain point the text dissapears from the cell and is replaced with ####. The text is still visable within the formula bar. I have tried increasing the size of the column and row and selected the autofit function, wrapped text etc. but it still keeps happening. I have no idea where to look next. Any advice?? -- Nat -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fitting text into a cell problem. Please help!
Nat
### Occurs when a column is not wide enough, or a negative date or time is used. Check for the text being written in the cell, is it generating an answer falls in the above two categories. Aqib Rizvi |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fitting text into a cell problem. Please help!
Actually, there are a few more things that can cause this:
1. The columnwidth is too narrow to show the number. Widen the column or change the font size of that cell. Or change the numberformat to General. 2. You have a date/time in that cell and it's negative Don't use negative dates. If excel was helping you, it may have changed the format to a date. Change it back to General (or some other number format). If you need to see negative date/times: Tools|options|Calculation Tab|and check 1904 date system (but this can cause trouble--watch what happens to your dates and watch what happens when you copy|paste dates to a different workbook that doesn't use this setting) 3. You have a lot of text in the cell, the cell is formatted as Text. Format the cell as general. 4. You really have ###'s in that cell. Clean up that cell. 5. You have # in a cell, but it's format is set to Fill. Change the format (format|cells|alignment tab|horizontal box, change it to General. Aqib Rizvi wrote: Nat ### Occurs when a column is not wide enough, or a negative date or time is used. Check for the text being written in the cell, is it generating an answer falls in the above two categories. Aqib Rizvi -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fitting cell to typed word | Excel Discussion (Misc queries) | |||
Fitting text in designated columns/rows | Excel Discussion (Misc queries) | |||
Automatically fitting cell sizes to contents | Excel Discussion (Misc queries) | |||
Check Boxes and Fitting to Cell | Excel Discussion (Misc queries) | |||
Wrapping in Excel (fitting many lines of text in cell to print rig | Excel Discussion (Misc queries) |