| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel cell shows and prints as hash marks (#)
I have a cell with text in it, and i can see it when I double-clink on the
cell and edit the text. However, the regular diaply of the cell shows a string of hash marks, and so does print preview. Anyone seen this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel cell shows and prints as hash marks (#)
It sounds like your cell is formatted as text and you have more than 255
characters in the cell. Change the format to General and all should be well. Cells formatted as text will show # if the length of the text is between 255 and 1024 characters. -- HTH... Jim Thomlinson "Phil Mead" wrote: I have a cell with text in it, and i can see it when I double-clink on the cell and edit the text. However, the regular diaply of the cell shows a string of hash marks, and so does print preview. Anyone seen this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel cell shows and prints as hash marks (#)
Your column width is too small. Increase the column size. (Or the row size,
and use word wrap) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Phil Mead" wrote: I have a cell with text in it, and i can see it when I double-clink on the cell and edit the text. However, the regular diaply of the cell shows a string of hash marks, and so does print preview. Anyone seen this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel cell shows and prints as hash marks (#)
Numbers show up as # but not text. Text is just truncated.
-- HTH... Jim Thomlinson "Luke M" wrote: Your column width is too small. Increase the column size. (Or the row size, and use word wrap) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Phil Mead" wrote: I have a cell with text in it, and i can see it when I double-clink on the cell and edit the text. However, the regular diaply of the cell shows a string of hash marks, and so does print preview. Anyone seen this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show text instead of hash marks | Excel Discussion (Misc queries) | |||
| GETTING RID OF LEADING HASH MARKS | Excel Discussion (Misc queries) | |||
| Graph with large data range (hash marks on axis) | Excel Discussion (Misc queries) | |||
| Show hash marks instead of text | Excel Worksheet Functions | |||
| Hash marks in a chart | Charts and Charting in Excel | |||
Linear Mode
