Formatting table column to currency

I’m trying to format a column of a table to currency but when I pull the number from my sqlite database it dosen’t show up in the table. If I remove the formatting from the column the number will show up in the table. Is there something I’m missing?

how is it formatted in your database?

First I tried not setting a data type in the database and then I tried setting it to decimal(10,2) and neither one worked. Not sure if it matters but the text field that I use to put the number in the database is formatted to currency. When I look at the database in the sqlite browser the number looks like 290.0