Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: ###### in Excel Column

    Using ADO and ASP I managed to upgrade a Excel Sheet.
    When I opened the Sheet I noticed that some Columns are filled with a line of #
    Does anyone why is the cause of this, and how I can prevent it?
    Because when I save the xls sheet to csv sheet, the lines of # end up in the sheet, and that is not what I would like to happen.

  2. #2
    Join Date
    Oct 2003
    Posts
    17
    The column size is not sufficient for some of the cells hence you see the ####. Try the AutoFit method of the columns.
    For example

    Columns("B:B").EntireColumn.AutoFit will adjust the column widht to fit the maximum lenght string in it.

  3. #3
    Join Date
    Nov 2003
    Posts
    2

    Thumbs up Problem allready solved

    Thank you for the reply, but I allready solved the problem. Because the colomn was set to "text" type it displayed the ### because the string was to long. I solved the problem bij setting the colomn type to "general" instead.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •