Hi, I have an excel spreadsheet

[FengShui1998]

Hi,

I have an excel spreadsheet that has a cell value of 4.30. When I'm reading it in from vbscript the value becomes 4.3. Is there a way to make sure I can see "4.30" instead of "4.3"?

Thanks,

Fengshui1998

 

[dsi]

How are you reading it in using VB Script? If you are using the Range object, just read the Text property instead of the Value property. This should give you the displayed value. If you specifically want two decimal places, use the Format(CellValue, "0.00&quot method.