Numbers dissapear when I change the field type to number


I created a table where I have a list of my sales. I imported this table from google sheets as a CSV file.

In this table I have 3 fields which contain Unit cost, unit price of sale and total sale. When I imported the table everything was as plain text, thus not having any “$” sign, just plain number.

Once imported to baserow and when I change the field type to number (It imports by default to text), all the data in my column dissapears.

Can someone help me understand what is happening?


Hi @SantiagoHernandez, would you be able to share which cell values were exactly in the text input before you converted it into a number?