Converting text to number & formatting

[CottageKeeper]

I have expense fields set to ‘Allow Negative Numbers’. It would be really helpful to just enter 5.24 and have that field make it a negative number. I have a ton of fields I need to manually enter the currency for and trying to remember to add the minus sign for the expense fields is proving challenging.

Is there anyway to 5.24 and have it show up as -5.24? If this is possible will the negative field currency now translate in formula when summing several currency fields with a formula?

Many thanks :pray:

[JonathanBowen]

Hi @CottageKeeper - you can’t get Airtable to automatically make the value negative in a single field. But what you could do is have an “entry” field and a “value” field:

The “Expense entry” field is just for data entry and the value field is what gets used in your base, calculations, formulas and so on. The formula I have in this field is:

IF({Expense entry}, {Expense entry} * -1)

The expense entry field can be hidden in the views where it doesn’t make sense to show it.