Hi Galstar,
You have to change the data type of the datatable manually, here are steps,
1.Select the column of the datatable and right click
2. Click on Format and Custom Number--> Select Type as "0.00" and click on OK
There is another way to avoid this manually by entering the data as ="29.00" in the datatable cell. check the below code
Let me know if this works for you
Thanks
Vinod
You have to change the data type of the datatable manually, here are steps,
1.Select the column of the datatable and right click
2. Click on Format and Custom Number--> Select Type as "0.00" and click on OK
There is another way to avoid this manually by entering the data as ="29.00" in the datatable cell. check the below code
Code:
DataTable.Value(2,1) = "="&chr(34)&"29.00"&chr(34)Let me know if this works for you
Thanks
Vinod

