Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text appear in formula bar but not in cell
Hi,
With reference to the subject, I have tried Wrap text and Rows/Columns Autofit but nothing works. Also all the typed text does not appear in the printout. Please advise. |
#2
|
|||
|
|||
Try this. Go to Edit -- Clear -- Formats. I think this will solve the problem. If not mail me the sheet on -- sanskar_d ------------------------------------------------------------------------ sanskar_d's Profile: http://www.excelforum.com/member.php...o&userid=24217 View this thread: http://www.excelforum.com/showthread...hreadid=378472 |
#3
|
|||
|
|||
Usman,
Is your font colour set to white? Is your number format set to ;;; (don't display anything)? Try changing your font colour to black, or the number format to "0.00" (for example) Hope this helps Pete "Usman Meer" wrote: Hi, With reference to the subject, I have tried Wrap text and Rows/Columns Autofit but nothing works. Also all the typed text does not appear in the printout. Please advise. |
#4
|
|||
|
|||
Usman
Excel Help on "limits" or "specifications" reveals that Excel will allow 32,767 characters to be entered in a cell. However, it goes on to state that "only 1024 characters will be visible or can be printed" To work around this limitation, stick a few ALT + ENTERs in at appropriate spots. The ALT + ENTER forces a line-feed and expands the 1024 limit. How far is not really known. Just experiment. .........From Dave Peterson.......... I put this formula in A1: ="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy" And adjusted the columnwidth, rowheight and font size and I got about 7300 characters to print ok. .........End Dave P................. Failing that, use a Text Box to store the text. Gord Dibben Excel MVP On Mon, 13 Jun 2005 00:59:02 -0700, "Usman Meer" <Usman wrote: Hi, With reference to the subject, I have tried Wrap text and Rows/Columns Autofit but nothing works. Also all the typed text does not appear in the printout. Please advise. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Some text shows in the formula bar but not in the cell. | Excel Discussion (Misc queries) | |||
Text in Cell as Formula | Excel Discussion (Misc queries) | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
reference the result of a formula in a text formatted cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |