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

The number data type is probably set to Integer or Long. Those are integer data types and do not store decimal values. Change the type to Currency, Double, or Single.

Excellent - thanks for that (very simple wasn't it!!).

All the best,


Roly