Stop number rounding in numeric fields?

[jp1]

I am entering 2 decimal place numbers (5.50) in a numeric field with the format set to fixed (3456.78) yet the values that appear in the table are immediately rounded up (5.50 becomes 6.00).&nbsp;&nbsp;&nbsp;What am I doing wrong?&nbsp;&nbsp;The guys that are getting paid by these changes (an hours tracking function submitted to payroll) will really like it, but management might take a dim view.&nbsp;&nbsp;Any help?<br><br>Thanks

 

[Vandys]

Use a Number field to store numeric data to be used for mathematical calculations, except calculations that involve money or that require a high degree of accuracy. Change the data type from number to currency. This will solve the problem.<br><br>Vandys

 

[jp1]

vandys - gosh, what can i say - you're right everything is now accurate.&nbsp;&nbsp;Thanks a bunch for the small pointer.&nbsp;&nbsp;My boss thinks I am worth my weight in oatmeal.&nbsp;&nbsp;<br><br>thanks again<br>jp1