Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I get # symbols in my cell instead of text
I have large blocks of text in some of my cells and they show up as
########## instead of the text I put there. If I click on the cell I see my text above in the text edit box, but not on the spreadsheet. |
#2
|
|||
|
|||
I believe there is a maximum number of characters in a cell before ### shows
for everything. "Betsy" wrote: I have large blocks of text in some of my cells and they show up as ########## instead of the text I put there. If I click on the cell I see my text above in the text edit box, but not on the spreadsheet. |
#3
|
|||
|
|||
"Betsy" wrote in message
... I have large blocks of text in some of my cells and they show up as ########## instead of the text I put there. If I click on the cell I see my text above in the text edit box, but not on the spreadsheet. Try widening the column |
#4
|
|||
|
|||
I have widened it as far as possible and still no luck.
"Betsy" wrote: I have large blocks of text in some of my cells and they show up as ########## instead of the text I put there. If I click on the cell I see my text above in the text edit box, but not on the spreadsheet. |
#5
|
|||
|
|||
I seem to be only at 250 characters... what is the limit?
"Betsy" wrote: I have large blocks of text in some of my cells and they show up as ########## instead of the text I put there. If I click on the cell I see my text above in the text edit box, but not on the spreadsheet. |
#6
|
|||
|
|||
### sometimes occur when you create formulas that result in negative time
values, which isn't possible. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Betsy" wrote in message ... I have widened it as far as possible and still no luck. "Betsy" wrote: I have large blocks of text in some of my cells and they show up as ########## instead of the text I put there. If I click on the cell I see my text above in the text edit box, but not on the spreadsheet. |
#7
|
|||
|
|||
Betsy, when you click on the cell, what is the content of the formula bar?
******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Betsy" wrote in message ... I seem to be only at 250 characters... what is the limit? "Betsy" wrote: I have large blocks of text in some of my cells and they show up as ########## instead of the text I put there. If I click on the cell I see my text above in the text edit box, but not on the spreadsheet. |
#8
|
|||
|
|||
If it's text, try changing the format of that cell to General.
Long text (255 characters to 1024 characters) in cells formatted as Text will show as ####'s. Betsy wrote: I have large blocks of text in some of my cells and they show up as ########## instead of the text I put there. If I click on the cell I see my text above in the text edit box, but not on the spreadsheet. -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
I get # symbols in my cell instead of text
Thank you Dave "Dave Peterson" wrote: If it's text, try changing the format of that cell to General. Long text (255 characters to 1024 characters) in cells formatted as Text will show as ####'s. Betsy wrote: I have large blocks of text in some of my cells and they show up as ########## instead of the text I put there. If I click on the cell I see my text above in the text edit box, but not on the spreadsheet. -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
I get # symbols in my cell instead of text
Thanks, Dave. That was the exact answer I needed for a block of merged cells
that was limiting my entry and displaying only ####. "Dave Peterson" wrote: If it's text, try changing the format of that cell to General. Long text (255 characters to 1024 characters) in cells formatted as Text will show as ####'s. Betsy wrote: I have large blocks of text in some of my cells and they show up as ########## instead of the text I put there. If I click on the cell I see my text above in the text edit box, but not on the spreadsheet. -- Dave Peterson |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
I get # symbols in my cell instead of text
Just hit this - the free microsoft works spreadsheet doesnt have this limit,
so what works in MS Works, fails after paying for excel2007. This doesn't seem like an intentional limit, do you know if MS is aware of it or if there is a way to open a bug report? " "Dave Peterson" wrote: If it's text, try changing the format of that cell to General. Long text (255 characters to 1024 characters) in cells formatted as Text will show as ####'s. Betsy wrote: I have large blocks of text in some of my cells and they show up as ########## instead of the text I put there. If I click on the cell I see my text above in the text edit box, but not on the spreadsheet. -- Dave Peterson |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
I get # symbols in my cell instead of text
First, I don't think that MSWorks is free--it may have been bundled with your pc
when you purchased the pc, but I'm sure the price of the software was buried into the price of the pc. Second, I'm sure that MS is aware of the behavior. Wayne wrote: Just hit this - the free microsoft works spreadsheet doesnt have this limit, so what works in MS Works, fails after paying for excel2007. This doesn't seem like an intentional limit, do you know if MS is aware of it or if there is a way to open a bug report? " "Dave Peterson" wrote: If it's text, try changing the format of that cell to General. Long text (255 characters to 1024 characters) in cells formatted as Text will show as ####'s. Betsy wrote: I have large blocks of text in some of my cells and they show up as ########## instead of the text I put there. If I click on the cell I see my text above in the text edit box, but not on the spreadsheet. -- Dave Peterson -- Dave Peterson |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
I get # symbols in my cell instead of text
Yes, I am sure it was bundled in, but it is the low end product - Free was
excessive freedom of expression. The point being that the low end product supported more than the high end one. "Dave Peterson" wrote: First, I don't think that MSWorks is free--it may have been bundled with your pc when you purchased the pc, but I'm sure the price of the software was buried into the price of the pc. Second, I'm sure that MS is aware of the behavior. Wayne wrote: Just hit this - the free microsoft works spreadsheet doesnt have this limit, so what works in MS Works, fails after paying for excel2007. This doesn't seem like an intentional limit, do you know if MS is aware of it or if there is a way to open a bug report? " "Dave Peterson" wrote: If it's text, try changing the format of that cell to General. Long text (255 characters to 1024 characters) in cells formatted as Text will show as ####'s. Betsy wrote: I have large blocks of text in some of my cells and they show up as ########## instead of the text I put there. If I click on the cell I see my text above in the text edit box, but not on the spreadsheet. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to reference a text cell that changes weekly in Header or Foo. | Excel Discussion (Misc queries) | |||
Text wider than one cell is not displayed in the next empty cell | Excel Discussion (Misc queries) | |||
Moving text from one cell to another. | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Forcing text onto new line in cell | New Users to Excel |