Hi
if each element in your pagearray is a numeric value why not convert it
to a number before inserting it into Excel (don't know the C# syntax
for this).

--
Regards
Frank Kabel
Frankfurt, Germany


Tommy wrote:
well it's actually kind of tricky, i grab a bunch of pay roll
information and create an area for each cell in a row, then i add
that
row to an array of rows for the whole page and then i add it to
excel,[i]
but theres a bunch of extra formatting i do

for(int i = 0; i < pagearray.Length; i++)
{
//add 2 to the array to add values in after the headers
int irow = i + 2;
Excel.Range range = (Excel.Range)sheet.Cells.get_Range("A" +
irow.ToString().Trim(),"P" + irow.ToString().Trim());
range.Value2 = pagearray;

//this is the relevant part of the code

Frank Kabel wrote:

Hi
could you post the relevant part of your code that inserts the
values
in Excel

--
Regards
Frank Kabel
Frankfurt, Germany


Tommy wrote:

i'm writing code in C# that uses a string array to insert a row of
fields into an excel sheet, at the end of the excel sheet i have a
cell that is suppose to calculate the total of a column, it won't
add the total because my numbers are being inserted as text, any
easy fixes??