Re: Pound Signs Instead Of Text

From: RagDyeR (ragdyer_at_cutoutmsn.com)
Date: 02/09/05


Date: Wed, 9 Feb 2005 07:34:19 -0800

Format the cell(s) to "General".

There seems to be a quirk (bug), where in a Text formatted cell of more then
approximately 256 characters, you'll get the ###'s.

Stranger yet, if you keep typing, the true text *returns* when the character
count exceeds 1024.

General format should work for the "in-between" character count.

-- 
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"SleepyDawn" <SleepyDawn@discussions.microsoft.com> wrote in message
news:6A1295C3-A558-4279-B882-AAEBD8E7CF15@microsoft.com...
I have been using Excel (XP) to make a text chart for some time now. Some
entries are quite lengthy. I've not had a problem until last week when my
lengthy entries started showing up as pound signs (######) instead of text
as
soon as I click off of the cell. I tried changing the width of the cell and
shortening my entry to no avail. The cell is formatted as "text" and "wrap
to
fit". I know the text can fit because when I'm editing it, it fits. This
chart is due to my professor tomorrow, please help!


Relevant Pages

  • Re: Real Meaning of Apostrophe?
    ... You can use the format ... If the apostrophe is seen as formatting, why doesn't it get copied when I ... Special | Format to a cell that doesn't have one? ... Returns the prefix character for the cell. ...
    (microsoft.public.excel.programming)
  • Re: Word mail merge code help
    ... If you embed your MERGEFIELD inside another field, coded, thus: ... column that is only wide enough for 1 character, ... To control the overall size of the bar, simply format the '?' ... one cell of the table changes color; ...
    (microsoft.public.word.vba.general)
  • Re: Real Meaning of Apostrophe?
    ... It isn't formatting in the same sense as cell formatting; ... You can use the format ... Returns the prefix character for the cell. ...
    (microsoft.public.excel.programming)
  • Re: Square-box character in data import
    ... It's not a formatting problem I don't ... think - it's a character that just shouldn't be there! ... > on my toolbar), drag the paintbrush symbol to the cell you want to change, ... > and that fixed the format down the whole column. ...
    (microsoft.public.excel.misc)
  • Re: importing undelimited text file data, character-by-character
    ... Try with the many zeros format. ... > '4.44444444222222E+22' in the formula box when the cell is selected. ... >>> character goes into a separate cell. ... >>> the string functions to move it to the appropriate cell. ...
    (microsoft.public.excel.programming)