Re: Pound Signs Instead Of Text
From: RagDyeR (ragdyer_at_cutoutmsn.com)
Date: 02/09/05
- Next message: NickDangr: "Modify Rounding Rules"
- Previous message: Earl Kiosterud: "Re: How do you disable save file dialog?"
- In reply to: SleepyDawn: "Pound Signs Instead Of Text"
- Messages sorted by: [ date ] [ thread ]
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!
- Next message: NickDangr: "Modify Rounding Rules"
- Previous message: Earl Kiosterud: "Re: How do you disable save file dialog?"
- In reply to: SleepyDawn: "Pound Signs Instead Of Text"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|