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
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

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.
 

Forum statistics

Threads
1,141,153
Messages
5,704,607
Members
421,359
Latest member
Edwardvanschothorst

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top