ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   ####### in Cell (https://www.excelbanter.com/excel-discussion-misc-queries/249372-cell.html)

PSULionRP

####### in Cell
 
I am typing text in a cell and then I get to a point and it just turns it to
a bunch of # signs...#####################

Why is that happening???

Thanks in advance for your review and hopeful for a reply.

PSULionRP

Dave Peterson

####### in Cell
 
Format the cell as General (or anything but Text) and reenter the value (F2
followed by Enter should be enough).

Excel has trouble strings between 256 and 1024 characters in cells formatted as
Text.

PSULionRP wrote:

I am typing text in a cell and then I get to a point and it just turns it to
a bunch of # signs...#####################

Why is that happening???

Thanks in advance for your review and hopeful for a reply.

PSULionRP


--

Dave Peterson

Luke M

####### in Cell
 
Increase your column width.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"PSULionRP" wrote:

I am typing text in a cell and then I get to a point and it just turns it to
a bunch of # signs...#####################

Why is that happening???

Thanks in advance for your review and hopeful for a reply.

PSULionRP



All times are GMT +1. The time now is 08:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com