Text Formatting in Cell

klre

New Member
Joined
Sep 29, 2006
Messages
2
What might cause text in a cell to appear as all ##### if the text does not excell the 1,024 character limit and the cell if formatted to wrap text
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
Perhaps sum negative dates or times in your cells?
 

xapie128

Board Regular
Joined
Aug 26, 2006
Messages
82
What might cause text in a cell to appear as all ##### if the text does not excell the 1,024 character limit and the cell if formatted to wrap text
My guess is that the text is being interpreted as a date and the column width is too narrow. Try making the column wider and see if the ##### goes away. If it is being interpreted as a date, and you want to force it to text, place the ( ' ) character (unshifted quote key next to the Enter key) in front of the text.

If that isn't the problem, then select a cell that shows #####, then copy its contents from the formula bar at the top and paste it here in the forum so we can take a look at it.
 

klre

New Member
Joined
Sep 29, 2006
Messages
2
Text formatting in a cell

The answer to why the text in the cell appeared as "####" when it did not exceed more than 250 characters appears to be that the cell must be formatted as Custom and the format is "#?/?". I don't quite understand why this is the case. It may have to do with the number of semi colons in the cell; there were quite a few. Thank you for your response.
 

Watch MrExcel Video

Forum statistics

Threads
1,111,493
Messages
5,541,041
Members
410,543
Latest member
ExcelGlenn
Top