[Solved] decimal numbers disappeared in Currency field

[IreneEng]

Good Morning
Field Type -> Number
Format: $0.00

But in the Table, when I enter 51.70, it shows $51.00

[Villeroy]

Ignore currency fields. Simply use formatted fields. Right-click>Replace With>Formatted Field. Formatted fields can be formatted like spreadsheet cells. Of course, the underlying column type of your database table should store decimals of a sufficient size. Column type Decimal(9,2) supports up to 9 digits including 2 points after the decimal point.

[IreneEng]

Thank you Herr Roy

Not working: I right licked the title in the Table -> Column Format, Field Format window opens up with this format code "[$$-409]#,##0.00;[RED]-[$$-409]#,##0.00" ... I didn't make any change since the example shown is what I need.

[Villeroy]

The data type of a table column has nothing to do with formatting.

RIght-click the table and choose "Edit"
Click the column in question. What is the data type, the lenght and the decimal digits?

[IreneEng]

Danke Herr R
It worked
Thank you for your patience!