Exporting Number 0878 to Excel as Text, loses starting 0

[dsworldtrip]

Hi,

Can't figure out how to export a Number with an initial 0 to Excel. For example :

if I want the cell to contain 0989

I do:

cell = sheet.getCell(currentRow, currentColumn);
cell.format = "text";
sheet.setCell(currentRow, currentColumn,cell.value);

But in Excel the value comes out as 989 and is stored in General Format.

There aren't any docs tat explain exatly how to use the .format property.

I also have other cells that I want to set in the number format, but cant seem to work that out either.

Any Ideas?