OWC11 Column formatting

[rusmo1]

Hello!

I am programtically importing a DataTable into a workbook using OWC11
and I'm having a problem because the default mode of column formatting
is "General". My problematic column's cells have significant leading
and trailing zeroes that are stripped off when the General Format is
applied to them. These cells occasionally contain letters, so some sort
of custom Numeric formatting does not appear to apply here. The proper
format for these cells is Text.

Example:
00.12340 gets imported as 0.1234

Berefore I add the data to the cells, I would like to set this column's
format to Text, but I do not know how to do this using the OWC11
inteface.

Could someone please show me how to do this? Sample code and/or links
will be appreciated.

Thanks in advance for your time!

 

[Josh Sale]

Try something like Range("C1").EntireColumn.NumberFormat = "@"

josh

 

[rusmo1]

Josh, that worked in the sense that it converted the column to the Text
format, but unfortunately my data is still screwed up in the same
manner when I view the generated Excel spreadsheet. Any clues on how to
force Excel to display the cell data exactly as entered?

Thanks, Will.

 

[Josh Sale]

Hmmm.

I don't know how to do that on a mass basis like changing the number format.
However if you prepend a sing apostrophe ( ' ) in front of each value as you
assign it to the cell, then OWC will definitely leave your values alone. I
can't remember how you were loading your data, but if its with an import,
then perhaps you can get the process that created the data file to provide
the needed apostrophes?

The leading apostrophe will not be displayed in the cell.

j