| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text shows up at all # symbols
I received an Excel file, and for an unknown reason, the text in just one of
the cells displays as all # symbols, even though I can see actual text in the preview screen. All of the other cells in the file display the text normally. Why would this happen and how can I fix it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text shows up at all # symbols
Excel has a problem with text strings between 255 characters and 1024
characters if the cell is formatted as Text. Format to General and your #### should go away. Gord Dibben MS Excel MVP On Thu, 3 Jun 2010 06:57:37 -0700, AKMMS wrote: I received an Excel file, and for an unknown reason, the text in just one of the cells displays as all # symbols, even though I can see actual text in the preview screen. All of the other cells in the file display the text normally. Why would this happen and how can I fix it? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text shows up at all # symbols
hi
try widening the column. Autofit. regards FSt1 "AKMMS" wrote: I received an Excel file, and for an unknown reason, the text in just one of the cells displays as all # symbols, even though I can see actual text in the preview screen. All of the other cells in the file display the text normally. Why would this happen and how can I fix it? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text shows up at all # symbols
For text?
Gord On Thu, 3 Jun 2010 07:09:01 -0700, FSt1 wrote: hi try widening the column. Autofit. regards FSt1 "AKMMS" wrote: I received an Excel file, and for an unknown reason, the text in just one of the cells displays as all # symbols, even though I can see actual text in the preview screen. All of the other cells in the file display the text normally. Why would this happen and how can I fix it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting ### (hash) symbols in text cell instead of text | Excel Discussion (Misc queries) | |||
| # symbols replacing text in a cell | Excel Discussion (Misc queries) | |||
| I get # symbols in my cell instead of text | Excel Discussion (Misc queries) | |||
| Extract text between symbols | Excel Discussion (Misc queries) | |||
| Text cell w/wrap text shows # | Excel Discussion (Misc queries) | |||
Linear Mode
