String - insert "0" and "."

[tantang]

Hi,

I have the datatable with string format and want to transform to the another datatable with string format as below:

I know we can use insert “0” and “.” but how can it work as expect for the data with “-” ? Please help me on this.

Thanks,
Tan.

[Yoichi]

Hi,

How about the following expression?

(Decimal.Parse(row("ColumnName").ToString)/1000000).ToString("0.000000")

Regards,

[tantang]

Thanks Yoichi, it worked as expectation.