I would like to create a formula in Google Sheets, in one whole column.
I have a currency field that I would like to place the decimal in cents i.e:
I would also like to include:
Right now the format is:
(with no decimal place)
I tried to add the decimal as an option in both Airtable and Google Sheets, but it formats it into dollars. I want it in cents, and also dollars, too. I have over 200 cells/records, so I don’t want to have to do this manually, but rather automatically, either by a formula or another method.
I appreciate any help.