table cells rounding

[Guest]

When using Number as a data type in several columns of a
table, the data is always rounded to the nearest whole
number. I tried changing the formatting to General Number,
but it's still rounding the data. i've tried to change to
change the formatting to decimal this also didn't work

 

[Lynn Trapp]

The default Field Size for a Number datatype is Long Integer. You should
change it to Single or Double if you need decimal places.