×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Microsoft: Office FAQ

Best of Excel

How to export those hashed (##) text cells by bigfoot
Posted: 30 Sep 09

If you ever need to deal with spreadsheet cells that are formatted as text and are full of long text values (exceeding 255 characters) you'll undoubtedly see those this hash marks or sometimes called number signs.
Excel uses these to tell you that it can not display a text cell larger then 255 characters.

If you try and export your spreadsheet to a comma or tab delimited format, the number signs (####) will be there too.

So what do you do?  You convert the column to the General format.  Yes it is that easy.
Excel will gladly show you all of the text and export it nicely.

Hope this helps someone.    

Back to Microsoft: Office FAQ Index
Back to Microsoft: Office Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close