####### in Cell

  • Thread starter Thread starter PSULionRP
  • Start date Start date
P

PSULionRP

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlighting a block of text within a cell 3
Insert Picture into a cell 1
I-con Picture and Text in Cell 1
Maximum Row Height Greater than 409.5 4
Shortcut keys for copying data down 29,000+ cells 2
Row Height beyond 260 4
Creating an Oracle UPDATE Statement from Excel rows 1
Multiple Hyperlinks in the same cell 1

Back
Top