Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to convert number to certain decimals but still keep the original

Topic Labels: Base design
Solved
Jump to Solution
662 5
cancel
Showing results for 
Search instead for 
Did you mean: 

I am putting different decimals accurate no. to my table, but I just want them to show in 2 decimals. Like in pop. column, I put 1.459868 and 1.84390809. I want them to show as 2 decimals but keep the original. So in one day I still can convert back to the originals. How to do that?

Nelson

1 Solution

Accepted Solutions

Welcome to the community, @Nelson_Quan!

Just create a formula field that looks like this:

ROUND({Number Field},2)

Replace “Number Field” with the name of your number field.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

See Solution in Thread

5 Replies 5

Welcome to the community, @Nelson_Quan!

Just create a formula field that looks like this:

ROUND({Number Field},2)

Replace “Number Field” with the name of your number field.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

Thanks. what you mean that I still need to leave the original column there and create another formula field there? Otherewised I can not use the same column when I put the formula.
if no, please give me a little bit more detail. Thanks so much.

thanks, but still bit disappointed , but generally, airtable is great still

I agree. Disappointing that a field needs a second field just for rendering. With this design, if there are five different rendering requirements for this field, you will need six fields in all - silly.

Ideally, rendering should be separated from values. Wait!!! We said that in 1998 with web content. There was an entire conferenced devoted to the separation of content from style. [sigh]