Excel ###### tags when copy and pasting

Whenever i copy and paste into Excel from notepad document the cell just fills with ######.

The cell is set to text format.

The cell is set to word wrap also.

greatful for guidance
row739Asked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
Set the cell format to General instead of Text (Text is only necessary if you have numbers that you want treated as text). If you use Text and the text is between 256 and 1024 characters, you will just see ####.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.