Problems with Number Formatting
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,