format a table cell

[Allen_Hart]

How do you format cells in a table to show numbers as 3-digit decimals?
I've tried this...

myTable.Cells(r, c).DataFormat = "#0.000" ' this does not work.

Is there more to it than this?

Allen

[Hallex]

Not tested

{code}
myTable.Cells(r, c).DataFormat = "%lu2%pr3%"
{code}

~'J'~

[Allen_Hart]

Thanks for the idea, but it does not work either.
There must be some special setup required prior to the assignment statement, but I can't find it.
Any other ideas?
Thanks,
Allen

[Hallex]

This code is working for me
just need to set DataType before:
{code}
oTable.SetDataType(i, j, DataType.Double, UnitType.Distance);
oTable.SetDataFormat(i, j, "%lu2%pr3");
{code}

~'J'~

[Allen_Hart]

Here is what I have now, which works OK.

{code}
Dim oDTP As New DataTypeParameter
oDTP.DataType = DataType.Double
oDTP.UnitType = UnitType.Unitless

'oTable.SetDataType(r, c, DataType.Double, UnitType.Distance) 'obsolete
'oTable.SetDataFormat(r, c, "%lu2%pr3%") 'obsolete

oTable.Cells(r, c).DataType = oDTP
oTable.Cells(r, c).DataFormat = "%lu2%pr3%"
{code}

If I assign a value to the cell like this:
oTable.Cells(r, c).Value = 1.0
it will ignore the format and display the number in 6 decimals.

Is there a list somewhere of defined dataformat strings?

Thanks for all your help.
Allen

[Hallex]

I'm still using A2008/Visual Studio2005
so it's not obsolete for me
Glad you have solved by yourself

~'J'~

[Hallex]

[SOLVED]

{quote}
If I assign a value to the cell like this:
oTable.Cells(r, c).Value = 1.0
it will ignore the format and display the number in 6 decimals.
{quote}

{code}oTable.Cells(r, c).DataFormat ="%lu2%pr2%th44" '<-- double with 2 decimals, %th44 = dot separated{code}

Works like a sharm

~'J'~

[Anonymous]

How to set data type to TEXT and format to Uppercase? Please help. Thanks!