Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text turns into ####
I am using excel 2003.
I created a calendar in Excel. One month on each sheet. On one sheet, I merged several cells together inorder to type a long statement. After I typed the statement and clicked on another cell, my first merged cell turned into all "#####". You can see the words in the tool bar, but on the screen you can only see #####. The merged cell is formatted for text, left alighned, Vertical (top), wrap text, merge cell, and left-to-right text direction. What am I missing to make this right? Aurora |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text turns into ####
You could widen the cell
"Aurora" wrote: I am using excel 2003. I created a calendar in Excel. One month on each sheet. On one sheet, I merged several cells together inorder to type a long statement. After I typed the statement and clicked on another cell, my first merged cell turned into all "#####". You can see the words in the tool bar, but on the screen you can only see #####. The merged cell is formatted for text, left alighned, Vertical (top), wrap text, merge cell, and left-to-right text direction. What am I missing to make this right? Aurora |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text turns into ####
You need to increase the size of the cell. Either make the column wider of
the row deeper... -- HTH... Jim Thomlinson "Aurora" wrote: I am using excel 2003. I created a calendar in Excel. One month on each sheet. On one sheet, I merged several cells together inorder to type a long statement. After I typed the statement and clicked on another cell, my first merged cell turned into all "#####". You can see the words in the tool bar, but on the screen you can only see #####. The merged cell is formatted for text, left alighned, Vertical (top), wrap text, merge cell, and left-to-right text direction. What am I missing to make this right? Aurora |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text turns into ####
Select the offending cell and reformat it as General (not text).
Aurora wrote: I am using excel 2003. I created a calendar in Excel. One month on each sheet. On one sheet, I merged several cells together inorder to type a long statement. After I typed the statement and clicked on another cell, my first merged cell turned into all "#####". You can see the words in the tool bar, but on the screen you can only see #####. The merged cell is formatted for text, left alighned, Vertical (top), wrap text, merge cell, and left-to-right text direction. What am I missing to make this right? Aurora -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text turns into ####
Mike wrote on Fri, 2 May 2008 11:09:00 -0700:
You could widen the cell. "Aurora" wrote: I am using excel 2003. I created a calendar in Excel. One month on each sheet. On one sheet, I merged several cells together inorder to type a long statement. After I typed the statement and clicked on another cell, my first merged cell turned into all "#####". You can see the words in the tool bar, but on the screen you can only see #####. The merged cell is formatted for text, left alighned, Vertical (top), wrap text, merge cell, and left-to-right text direction. What am I missing to make this right? Aurora I'm a bit puzzled because I did an experiment with text wider than the cells. It was cut off where there was text in the second column but otherwise spilled into it. I am using Excel 2002. -- James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text turns into ####
Excel has trouble displaying values in cells formatted as text when the length
of the string is between 255 and 1024 characters. James Silverton wrote: <<snipped I'm a bit puzzled because I did an experiment with text wider than the cells. It was cut off where there was text in the second column but otherwise spilled into it. I am using Excel 2002. -- James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
8-10 turns in 8 oct | Excel Discussion (Misc queries) | |||
Why number 8 turns into a 0? | Excel Discussion (Misc queries) | |||
Bug? Autocalculation turns itself on... | Excel Discussion (Misc queries) | |||
= sum value turns to text and formula disappears | Excel Worksheet Functions | |||
max number of wrap/turns in text wrapping? | Excel Discussion (Misc queries) |