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

[Nelson_Quan]

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

[ScottWorld · Accepted solution]

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:

[Nelson_Quan]

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.

[ScottWorld]

Yes, that is correct.

[Nelson_Quan]

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

[Bill_French]

Nelson_Quan:

thanks, but still bit disappointed

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]