Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula field - format=currency, can you append (M) to it?

Topic Labels: Base design
320 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,
I’m wondering if there is a way to append the letter M to a currency field. The field in question is a formula based on 2 other fields and the output is a number to 1 decimal point - ##.#, I’d like to format it in such a way that the letter M is appended to it since we know that all the values will be in the millions.

Is that possible? Same question for just standard currency format fields, where the user just enter something like 1.2, and it formats it as $1.2M.

Can either or both of those be done?

Thanks in advance for posting your question! When someone provides an answer, mark their reply as the :white_check_mark: solution to your topic.

0 Replies 0