NumberFormat not working
 

In my C# interop code I'm setting the NumberFormat property in the following
manner:

((Range)workSheet.Cells[rowIndex, columnIndex]).NumberFormat = "#0.0000";

Unfortunately this format is not being used in the generated spreadsheet.

What's weird is that if go to the "Format Cells" dialog and select "Custom"
the format string I set in code has been added to the format list. It's as if
it's been defined, but not been applied to the actual cell.

Any ideas on what's going on?

-Thx