Click to See Complete Forum and Search --> : excel output


baxish
September 16th, 2002, 12:07 PM
i am getting asp output as excel sheet.But if value in cell is 0102030 it shows only 102030 what to do???

Waldo2k2
September 16th, 2002, 05:07 PM
in excel, format the cell properties as text. By the definition of numbers in excel, preceding zero's are truncated. good luck.