Hi

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:

$0.05

I would also like to include:

$0.01

Right now the format is:

05

(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.

Thank you,

Mary