#############... appearing in a cell

rich7

Board Regular
Joined
May 17, 2004
Messages
52
The I enter long pieces of alpha numeric text into a cell, when click on another cell, the cell fills with # characters so all I see is #########################################.

But the formula bar displays the text I entered.

Any idea why this is happening - maximum charcters for a perhaps cell?

Thanks in advance.

I'm sure this must have been answered before but couldn't find it -search engines don't seem to like # characer.
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

lisauk5583

Board Regular
Joined
Dec 1, 2004
Messages
56
Rich,

Im pretty sure you just have to resize the column. Double clicking on the column header boarder line will automatically resize the column to the siz needed. Hope that makes sense.

Lisa
 

rich7

Board Regular
Joined
May 17, 2004
Messages
52
Thanks Lisa

Resizing didn't work for me but I found out that there's a limit of 255 characters in an Excel Cell. So as soon as I reduced the text to this number of chars it was all ok. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,335
Messages
5,595,573
Members
413,996
Latest member
mabelO

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