cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
phh
Helper IV
Helper IV

change the number of decimals for a number

Hi all,
I would like to change the number of decimals so that there are no decimals.
I do not know how to do it. I have see somone use "text" but I cannot choose "text"
Maybe it's below default?

I hope you can help me!

See the Picture   

Mvh
- Peter

1 ACCEPTED SOLUTION

Accepted Solutions

The only other thing I can think of - is 'Ha mangler' a SharePoint calculated field? There's a known problem with calculated fields not formatting correctly. If that's the case, you could also try this:

Round(
     Value(ThisItem.'Ha mangler'),
     2
)

View solution in original post

8 REPLIES 8
timl
Super User
Super User

Hi Peter,

If you try this, does it make a difference?

Text(ThisItem.'Ha mangler', "#.00")

 

Hi @timl,

Nothing is happening 😞

See the picture 

 
- Peter

Hi Peter,

If you try this (with a call to Value), does that make a difference?

Text(Value(ThisItem.'Ha mangler'), "#.00")

 

Hi @timl,

No 😞

see the picture

- Peter

The only other thing I can think of - is 'Ha mangler' a SharePoint calculated field? There's a known problem with calculated fields not formatting correctly. If that's the case, you could also try this:

Round(
     Value(ThisItem.'Ha mangler'),
     2
)

Hi @timl,

It is a calculated field? 

It still does not work 😞

See the picture.

- Peter 

Hiii @timl 

sorry it work 😄

thank you!!!

-Peter

Glad it all works now!

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,187)