###### in Excel Column

[karelmous]

Using ADO and ASP I managed to upgrade a Excel Sheet.
When I opened the Sheet I noticed that some Columns are filled with
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 u
in the sheet, and that is not what is suposed to happen

 

[Debbie K.]

Try widening the columes?

 

[Guest]

Did you try changing the column width? The only times I have received ##### in columns is when the column is not wide enough to display the number.

 

[neopolitan]

Typically, in Excel, this is an indication that the number in that cel
is too long to be displayed with the column width setting. Expand th
width of the column and the number should replace the ######

 

[mjwillyone]

It may also be that the decimal formatting (if it is a number) is set t
way to many decimals places. This happens to me once in a while. Jus
go in and format for fewer decimal places

 

[karelmous]

Well I think it could be the width of the column. I allready tried t
make the empty sheet that should be filled by the ASP applicatio
wider. It did'nt work. Some records are displayed normal others do not
Should the text be to long? If so is there some setting that has to b
changed to be able to have the # records displayed as well

 

[Dave Peterson]

I think I've seen #### show up in 3 instances:

Number (not formatted as General) that was too wide for the column.
(just widen the column to fix it)

Number formatted as Time/Date that contained negative values
(either fix the values or use the 1904 as your base date
Tools|options|Calculation tab is where you'd toggle this--but be careful,
your other dates will change, too.)

A String value that was really long and the cell was formatted as Text.
(Formatting the cell as General usually fixes this.)

 

[karelmous]

The problem accured indeed because the column was set to "text" instea
of "general". I solved the problem now. Thanks guys