Decimals

[DBaxter]

I wanted to set my "dimension" fields for consistency to
show 2 decimal places and if no whole figure would show a
0. So they would be 1.25 or 130.50 or 0.50, etc.

I just changed the field from text to number (long
integer) and said I wanted 2 decimal places. Now my data
is converted to whole numbers! Does anyone know why this
happened? And have I lost all the data I previously had?

 

[Fredg]

By definition, an Integer (Long or otherwise) is a whole number (no
decimals).

Change the Field's Size property to one of these.
Single
Double
Currency

Set the Field's Format property to Fixed
Set the Decimals property to 2