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

Topic Labels: Base design
Solved
2021 5
cancel
Showing results for
Did you mean:
4 - Data Explorer

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
18 - Pluto

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:

5 Replies 5
18 - Pluto

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:

4 - Data Explorer

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.

18 - Pluto

Yes, that is correct.

4 - Data Explorer

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

17 - Neptune

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]