Hi,

I have a problem with a table that has number formats setup as usual - #,##0.00;(#,##0.00) and formatted to 2dp. However when inputting say 1.58 into the table it will round to 2.00 and does not show any decimals except as .00. When I remove the number formatting and set the decimal place to Auto, or 1 the same occurs but no decimal places are showing.

Can anybody explain why this is happening? I have tried searching through the properties, etc. to no avail.

Thanks very much for your help,


Roly

roly,

In your table, make sure the number type is either single or double. It cannot be long or integer as these will round up or down.
Single or Double will keep the decimal places.

Kevin

dartcoach